Re: API change advice: Passing plan invalidation info from the rewriter into the planner?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: API change advice: Passing plan invalidation info from the rewriter into the planner?
Дата
Msg-id 2089.1402424381@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: API change advice: Passing plan invalidation info from the rewriter into the planner?  (Adam Brightwell <adam.brightwell@crunchydatasolutions.com>)
Ответы Re: API change advice: Passing plan invalidation info from the rewriter into the planner?  ("Brightwell, Adam" <adam.brightwell@crunchydatasolutions.com>)
Re: API change advice: Passing plan invalidation info from the rewriter into the planner?  (Craig Ringer <craig@2ndquadrant.com>)
Re: API change advice: Passing plan invalidation info from the rewriter into the planner?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Adam Brightwell <adam.brightwell@crunchydatasolutions.com> writes:
> Through this effort, we have concluded that for RLS the case of
> invalidating a plan is only necessary when switching between a superuser
> and a non-superuser.  Obviously, re-planning on every role change would be
> too costly, but this approach should help minimize that cost.  As well,
> there were not any cases outside of this one that were immediately apparent
> with respect to RLS that would require re-planning on a per userid basis.

Hm ... I'm not following why we'd need a special case for superusers and
not anyone else?  Seems like any useful RLS scheme is going to require
more privilege levels than just superuser and not-superuser.

Could we put the "if superuser then ok" test into the RLS condition test
and thereby not need more than one plan at all?
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Getting “make: Entering an iso-8859-1 directory” error while building postgresql on MIPS platform
Следующее
От: shreesha21
Дата:
Сообщение: Re: Getting “make: Entering an iso-8859-1 directory” error while building postgresql on MIPS platform