Mark Steben wrote: > I would like to vacuum full pg_attribute and some other postgres infrastructure tables to eliminate bloat. > Could you please confirm that the recommended method to do this is to > stop postgres, restart in single user mode, and issue the vacuum command? That is not necessary. Just run the VACUUM (FULL) as superuser. Concurrent access to pg_attribute will be blocked, which means that the database is pretty much unusable, but you don't need single user mode. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
