vacuum of pg_attribute and other infrastructure tables

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: vacuum of pg_attribute and other infrastructure tables
Date: 2019-05-02 15:36:35
Message-ID: CADyzmyy+SGTJ7maxOhyKamScCFi7czBM+O=vyfiC+oV5dbcxQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message SAMMY CRISWELL 2019-05-02 15:50:18 Psql: could not connect to server: No such file or directory
Previous Message pavan95 2019-05-02 13:19:32 Error while performing Vacuum