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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: hayato(dot)iida(dot)0213(at)gmail(dot)com
Subject: BUG #17599: After creating more than 10,000 roles, select becomes slow after role switching
Date: 2022-08-29 00:46:50
Message-ID: 17599-52eb32d8dc747e77@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17599
Logged by: hayato iida
Email address: hayato(dot)iida(dot)0213(at)gmail(dot)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)

Browse pgsql-bugs by date

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