Re: predefined role(s) for VACUUM and ANALYZE

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: predefined role(s) for VACUUM and ANALYZE
Date: 2022-07-25 04:39:31
Message-ID: 20220725043931.GA4087907@nathanxps13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Fri, Jul 22, 2022 at 01:37:35PM -0700, Nathan Bossart wrote:
> The attached patch adds a pg_vacuum_analyze role that allows VACUUM and
> ANALYZE commands on all relations. I started by trying to introduce
> separate pg_vacuum and pg_analyze roles, but that quickly became
> complicated because the VACUUM and ANALYZE code is intertwined. To
> initiate the discussion, here's the simplest thing I could think of.

And here's the same patch, but with docs that actually build.

Nathan Bossart
Amazon Web Services:

Attachment Content-Type Size
pg_vacuum_analyze_v2.patch text/x-diff 7.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2022-07-25 04:52:35 Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.
Previous Message mahendrakar s 2022-07-25 04:33:03 Re: A proposal for shared memory based backup infrastructure