Re: vacuum of pg_attribute and other infrastructure tables

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