BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching
Дата
Msg-id 17599-52eb32d8dc747e77@postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      17599
Logged by:          hayato iida
Email address:      hayato.iida.0213@gmail.com
PostgreSQL version: 14.5
Operating system:   docker image 14.4-alpine3.16 on mac
Description:

1. Apply row level security to table.
2. Register 10,000 roles
3. Register data in the table (only by registering a few items)
4. Switching to a role with row level security applied and executing sql
takes about 1 second (when executed again here, it returns in about 1 ms)

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17598: EXTENSION can no longer create it's own schema! (Create Schema IF NOT EXISTS XXX)
Следующее
От: jitesh tiwari
Дата:
Сообщение: Re: fetching bytea (blob) data of 850 MB from psql client failed