Re: PG 10 experience different user execute same sql get different access plan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PG 10 experience different user execute same sql get different access plan
Дата
Msg-id 3430781.1621436418@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PG 10 experience different user execute same sql get different access plan  (Zhiyu ZY13 Xu <xuzy13@lenovo.com>)
Ответы 回复: [External] Re: PG 10 experience different user execute same sql get different access plan  (Zhiyu ZY13 Xu <xuzy13@lenovo.com>)
Список pgsql-general
Дерево обсуждения 
Zhiyu ZY13 Xu <xuzy13@lenovo.com> writes:
>   I experience a PG optimizer problem. Different user query with same SQL at same time. But get different access
plan.

If you've got row-level security turned on for that table, it could
explain results like this.  RLS limits the planner's ability to
see statistics, which can easily result in a worse plan.

            regards, tom lane

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: The contents of the pg_timezone_names view bring some surprises
Следующее
От: Zhiyu ZY13 Xu
Дата:
Сообщение: 回复: [External] Re: PG 10 experience different user execute same sql get different access plan