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