Re: How bad is using queries with thousands of values for operators IN or ANY?

Поиск
Список
Период
Сортировка
От Thorsten Schöning
Тема Re: How bad is using queries with thousands of values for operators IN or ANY?
Дата
Msg-id 771535254.20200831111622@am-soft.de
обсуждение исходный текст
Ответ на How bad is using queries with thousands of values for operators IN or ANY?  (Thorsten Schöning <tschoening@am-soft.de>)
Список pgsql-general
Guten Tag Laurenz Albe,
am Montag, 31. August 2020 um 10:23 schrieben Sie:

> Is it an option to change that usage pattern?

Not everywhere easily, because I simply have places in which I'm
working with IDs only and e.g. need to check if they are owned by some
user. Those checks are abstracted away into individual functions
instead of JOINing always, as the latter makes queries more difficult
to maintain.

Of course there are alternatives like row level security I might have
a look at etc. And that's exactly why I asked the question, to make my
mind about that thing, if it's worth or necessary to look into
alternatives at all etc.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow




В списке pgsql-general по дате отправления:

Предыдущее
От: Thorsten Schöning
Дата:
Сообщение: Re: How bad is using queries with thousands of values for operators IN or ANY?
Следующее
От: "Yorwerth, Adam"
Дата:
Сообщение: Query performance with min and filter