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

From:	Nathan Bossart <nathandbossart(at)gmail(dot)com>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	pgsql-hackers(at)lists(dot)postgresql(dot)org, alex work <alexwork033(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject:	Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs
Date:	2024-03-22 16:54:48
Message-ID:	20240322165448.GA2350322@nathanxps13
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2024-03-21 07:10:06 from alex work <alexwork033(at)gmail(dot)com>  2024-03-21 07:59:29 from Dominique Devienne <ddevienne(at)gmail(dot)com>  2024-03-21 16:07:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎   2024-03-21 17:00:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2024-03-21 18:47:17 from walther(at)technowledgy(dot)de   2024-03-21 19:42:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎    2024-03-21 20:31:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2024-03-21 20:40:12 from Nathan Bossart <nathandbossart(at)gmail(dot)com>      2024-03-22 00:51:39 from Nathan Bossart <nathandbossart(at)gmail(dot)com>       2024-03-22 00:59:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2024-03-22 01:03:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>         2024-03-22 01:52:51 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎          2024-03-22 02:07:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2024-03-22 02:02:57 from alex work <alexwork033(at)gmail(dot)com>        2024-03-22 14:47:39 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎         2024-03-22 14:55:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>          2024-03-22 15:27:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2024-03-22 16:39:52 from Nathan Bossart <nathandbossart(at)gmail(dot)com>            2024-03-22 16:53:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2024-03-22 16:54:48 from Nathan Bossart <nathandbossart(at)gmail(dot)com>              2024-03-22 19:35:06 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2024-03-22 20:41:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2024-03-25 14:47:43 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                 2024-03-25 15:08:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2024-03-25 15:16:47 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                   2024-03-26 16:59:18 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                    2024-03-26 18:16:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                     2024-03-26 18:48:19 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                      2024-03-26 19:08:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2024-03-26 19:49:25 from Nathan Bossart <nathandbossart(at)gmail(dot)com>
Lists:	pgsql-general pgsql-hackers

In response to

• Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs at 2024-03-22 16:53:15 from Tom Lane

Responses

• Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs at 2024-03-22 19:35:06 from Nathan Bossart

Browse pgsql-general by date

	From	Date	Subject
Next Message	Matthias Apitz	2024-03-22 17:12:28	soft lockup - CPU#16 stuck for 3124s! [postmaster:2273]
Previous Message	Tom Lane	2024-03-22 16:53:15	Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David G. Johnston	2024-03-22 16:55:24	Re: documentation structure
Previous Message	Tom Lane	2024-03-22 16:53:15	Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs