Re: policies with security definer option for allowing inline optimization

Поиск
Список
Период
Сортировка
От Dan Lynch
Тема Re: policies with security definer option for allowing inline optimization
Дата
Msg-id CA+_muLF=DGpCOgn2nj7wUJhkh3cieDvuDg5zuHN1z8Xmmf5+kA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: policies with security definer option for allowing inline optimization  (Noah Misch <noah@leadboat.com>)
Ответы Re: policies with security definer option for allowing inline optimization
Список pgsql-hackers
Дерево обсуждения

> I suppose if the possibility exists that this could happen, perhaps using
> RLS for selects is not quite "production ready"?

I would not draw that conclusion.


This is great to hear! I'm betting a lot on RLS and have been investing a lot into it. 
 
> Or perhaps if the RLS
> qual/check is written well-enough, then maybe the performance hit wouldn't
> be noticed?

Yes.

Amazing to hear. Sounds like the path I'm on is good to go and will only improve over time :)  

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)?

Appreciate your info here!

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Stronger safeguard for archive recovery not to miss data
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: Parallel Full Hash Join