From: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: vacuum of pg_attribute and other infrastructure tables |
Date: | 2019-05-02 16:36:14 |
Message-ID: | CADyzmyzQMDy=bB1q+Bmg6oALVkEbi6w4A8BV_yNUzYKX9tHmSg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you for the clarification.
On Thu, May 2, 2019 at 12:10 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> 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
>
>
--
*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/>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-05-02 17:07:44 | Re: Psql: could not connect to server: No such file or directory |
Previous Message | Laurenz Albe | 2019-05-02 16:10:33 | Re: vacuum of pg_attribute and other infrastructure tables |