Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
Date
Msg-id 06ee895767b46f631327d7e029d46106a8a6fbe9.camel@j-davis.com
Whole thread Raw
In response to Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
List pgsql-hackers
On Tue, 2021-10-26 at 00:07 +0000, Bossart, Nathan wrote:
> It feels a bit excessive to introduce a new predefined role just for
> this.  Perhaps this could be accomplished with a new function that
> could be granted.

It would be nice if the syntax could be used, since it's pretty
widespread. I guess it does feel excessive to have its own predefined
role, but at the same time it's hard to group a command like CHECKPOINT
into a category. Maybe if we named it something like pg_performance or
something we could make a larger group?

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Spelling change in LLVM 14 API
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: prevent immature WAL streaming