BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching
Date
Msg-id 17599-52eb32d8dc747e77@postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17598: EXTENSION can no longer create it's own schema! (Create Schema IF NOT EXISTS XXX)
Next
From: jitesh tiwari
Date:
Subject: Re: fetching bytea (blob) data of 850 MB from psql client failed