From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Mark Steben <mark.steben@drivedominion.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: vacuum of pg_attribute and other infrastructure tables
Date: Thu, 02 May 2019 18:10:33 +0200
Message-ID: <3e07076a17ae160c230dd3685fedc5d53f83e19d.camel@cybertec.at> (raw)
In-Reply-To: <CADyzmyy+SGTJ7maxOhyKamScCFi7czBM+O=vyfiC+oV5dbcxQA@mail.gmail.com>
References: <CADyzmyy+SGTJ7maxOhyKamScCFi7czBM+O=vyfiC+oV5dbcxQA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, mark.steben@drivedominion.com
Subject: Re: vacuum of pg_attribute and other infrastructure tables
In-Reply-To: <3e07076a17ae160c230dd3685fedc5d53f83e19d.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox