Re: Full list of operations that constitute a "maintenance" operation?

Lance Luvaul wrote:
> Hi all, I've read on the Postgres documentation for 'maintenance_work_mem' that VACUUM, CREATE INDEX,
> and ALTER TABLE ADD FOREIGN KEY are considered maintenance operations, but are there others?
> For example I use ALTER TABLE ADD COLUMN and ALTER TABLE SET LOGGED in my scripts...
> are they maintenance operations that would cause a maintenance_work_mem-sized chunk of memory
> (or more than 1 such chunk) to be allocated? Is there a complete list somewhere? Thanks!

Trawling the source shows that it is used for index operations like CREATE INDEX and REINDEX,
but also for ALTER TABLE ADD FOREIGN KEY, VACUUM and CLUSTER.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com