From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
---|---|
To: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: predefined role(s) for VACUUM and ANALYZE |
Date: | 2022-09-07 22:21:29 |
Message-ID: | 20220907222129.GB2095022@nathanxps13 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Sep 07, 2022 at 02:53:57PM -0700, Mark Dilger wrote:
> Assuming for the sake of argument that we should create a role something like you propose, can you explain why we should draw the line around just VACUUM and ANALYZE? I am not arguing for including these other commands, but don't want to regret having drawn the line in the wrong place when later we decide to add more roles like the one you are proposing.
There was some previous discussion around adding a pg_maintenance role that
could perform all of these commands [0]. I didn't intend to draw a line
around VACUUM and ANALYZE. Those are just the commands I started with.
If/when there are many of these roles, it might make sense to create a
pg_maintenance role that is a member of pg_vacuum_all_tables,
pg_analyze_all_tables, etc.
[0] https://postgr.es/m/67a1d667e8ec228b5e07f232184c80348c5d93f4.camel%40j-davis.com
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Smith | 2022-09-07 22:31:52 | Re: Column Filtering in Logical Replication |
Previous Message | Nathan Bossart | 2022-09-07 22:11:03 | Re: predefined role(s) for VACUUM and ANALYZE |