Обсуждение: BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching

Поиск
Список
Период
Сортировка

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

От
PG Bug reporting form
Дата:
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)