Re: predefined role(s) for VACUUM and ANALYZE

From:	Nathan Bossart <nathandbossart(at)gmail(dot)com>
To:	Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:	Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: predefined role(s) for VACUUM and ANALYZE
Date:	2022-11-18 17:05:04
Message-ID:	20221118170504.GA401589@nathanxps13
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-07-22 20:37:35 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎  2022-07-25 04:39:31 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎  2022-07-25 07:28:36 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>   2022-07-25 16:40:49 from Nathan Bossart <nathandbossart(at)gmail(dot)com>    2022-07-26 01:47:12 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>     2022-07-26 01:58:14 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>     2022-07-26 17:37:37 from Robert Haas <robertmhaas(at)gmail(dot)com>      2022-07-26 17:50:32 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>       2022-07-26 17:54:38 from Robert Haas <robertmhaas(at)gmail(dot)com>        2022-07-27 05:24:29 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>        2022-07-28 22:26:02 from Nathan Bossart <nathandbossart(at)gmail(dot)com>        2022-08-23 23:46:47 from Stephen Frost <sfrost(at)snowman(dot)net>         2022-09-05 18:56:30 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎          2022-09-06 12:26:55 from Robert Haas <robertmhaas(at)gmail(dot)com>          2022-09-06 15:11:51 from Stephen Frost <sfrost(at)snowman(dot)net>           2022-09-06 15:24:18 from Robert Haas <robertmhaas(at)gmail(dot)com>            2022-09-06 15:54:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2022-09-07 21:13:44 from Stephen Frost <sfrost(at)snowman(dot)net>              2022-09-07 22:11:03 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2022-09-07 23:09:05 from Stephen Frost <sfrost(at)snowman(dot)net>                2022-09-07 23:15:23 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                 2022-09-09 22:10:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                2022-09-08 05:50:35 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                2022-09-08 13:41:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2022-09-20 03:51:47 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                  2022-09-20 05:45:52 from Michael Paquier <michael(at)paquier(dot)xyz>                   2022-09-20 18:05:33 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                    2022-09-20 23:31:17 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                     2022-09-20 23:50:10 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                      2022-09-21 01:31:47 from Michael Paquier <michael(at)paquier(dot)xyz>                       2022-09-21 04:31:26 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                        2022-09-28 18:50:34 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                         2022-09-28 19:09:46 from Stephen Frost <sfrost(at)snowman(dot)net>                          2022-09-28 20:12:22 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                           2022-09-30 19:23:50 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                            2022-09-30 20:15:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2022-09-30 21:47:28 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                              2022-09-30 22:00:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                               2022-09-30 22:32:57 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                2022-09-30 23:05:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2022-09-30 23:18:34 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                  2022-10-14 23:37:38 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                   2022-11-14 23:40:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                    2022-11-15 05:08:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                     2022-11-16 20:09:47 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                      2022-11-17 04:39:52 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                       2022-11-18 17:05:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                        2022-11-19 18:50:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                         2022-11-20 16:57:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                          2022-11-23 19:56:28 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                           2022-11-23 23:54:44 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                            2022-11-28 17:13:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                             2022-11-28 18:52:47 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                             2022-12-05 20:21:08 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                              2022-12-06 00:04:14 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                               2022-12-06 13:57:37 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                2022-12-06 19:38:09 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                            2022-12-06 11:47:50 from Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org> 📎                                             2022-12-06 19:51:08 from Nathan Bossart <nathandbossart(at)gmail(dot)com>          2022-09-06 17:47:49 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎  2022-09-07 21:53:57 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>   2022-09-07 22:21:29 from Nathan Bossart <nathandbossart(at)gmail(dot)com>    2022-09-07 22:50:13 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v10-0001-Change-AclMode-from-a-uint32-to-a-uint64.patch	text/x-diff	7.4 KB
v10-0002-Simplify-WARNING-messages-emitted-when-skipping-.patch	text/x-diff	15.8 KB
v10-0003-Allow-granting-VACUUM-and-ANALYZE-privileges-on-.patch	text/x-diff	39.1 KB
v10-0004-Add-pg_vacuum_all_tables-and-pg_analyze_all_tabl.patch	text/x-diff	9.4 KB

In response to

• Re: predefined role(s) for VACUUM and ANALYZE at 2022-11-17 04:39:52 from Nathan Bossart

Responses

• Re: predefined role(s) for VACUUM and ANALYZE at 2022-11-19 18:50:04 from Nathan Bossart

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2022-11-18 17:32:10	Re: Avoid double lookup in pgstat_fetch_stat_tabentry()
Previous Message	Robert Haas	2022-11-18 16:59:59	Re: Allow single table VACUUM in transaction block