Postgres Pro
Downloads
Home   >   mailing lists

vacuum of pg_attribute and other infrastructure tables - Mailing list pgsql-admin

From Mark Steben
Subject vacuum of pg_attribute and other infrastructure tables
Date
Msg-id CADyzmyy+SGTJ7maxOhyKamScCFi7czBM+O=vyfiC+oV5dbcxQA@mail.gmail.com
Whole thread Raw
Responses Re: vacuum of pg_attribute and other infrastructure tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
Good morning,

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?

Thank you,
Mark 

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Error while performing Vacuum
Next
From: SAMMY CRISWELL
Date:
Subject: Psql: could not connect to server: No such file or directory