Re: policies with security definer option for allowing inline optimization

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: policies with security definer option for allowing inline optimization
Дата
Msg-id 20210407022304.GA847424@rfd.leadboat.com
обсуждение исходный текст
Ответ на Re: policies with security definer option for allowing inline optimization  (Dan Lynch <pyramation@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Apr 06, 2021 at 01:16:16PM -0700, Dan Lynch wrote:
> Final question: do you think using procedures vs writing inline queries for
> RLS quals/checks has a big difference in performance (assuming functions
> are sql)?

If the function meets the criteria for inlining (see inline_function()),
there's negligible performance difference.  Otherwise, the performance
difference may be large.

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Allow batched insert during cross-partition updates
Следующее
От: Japin Li
Дата:
Сообщение: Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax