Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs
Дата
Msg-id CAFCRh-_w4sRJ12X05Qojf=1_w_EBP_Gq33Vsa6hSpev_hEpvsA@mail.gmail.com
обсуждение исходный текст
Ответ на Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs  (alex work <alexwork033@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Mar 21, 2024 at 8:10 AM alex work <alexwork033@gmail.com> wrote:
We encounter slow `GRANT ROLES` only on PostgreSQL 16 instances up to 42 seconds
in production, the client process at PostgresSQL would use 100% of the CPU. [...]
Using ROLE `acc`, grant `d_` ROLE to a session ROLE:
real    0m7.579s [...] 
PostgreSQL 15
Using ROLE `acc`, grant `d_` ROLE to a session ROLE:
real    0m0.077s

Ouch, that's a ~ 100x regression. Thanks for the write-up, that's worrying.
We don't have as many ROLEs, but we do have plenty, so this is worrying.

On top of the v16 ROLE changes breaking on ROLE logic, which was fine prior (v12-v15).
We've paused for now our planned v16 upgrade, until we have more time to adapt.

Like you, I welcome the changes. But it turns out more expensive to adapt to them.
And your report certainly makes me wonder whether we should hold off until that perf regression is addressed.

Thanks, --DD

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

Предыдущее
От: alex work
Дата:
Сообщение: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs
Следующее
От: Joseph Kennedy
Дата:
Сообщение: Question about PostgreSQL upgrade from version 12 to version 15