pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Artem Tomyuk <admin@leboutique.com>
To: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: pg_attribute getting bloated in size
Date: Fri, 14 Dec 2018 15:33:32 +0100
Message-ID: <c742bb3b991357b9aba06b3985630e0e9372fed2.camel@cybertec.at> (raw)
In-Reply-To: <CANYYVqKrU=8gxLU_5=zd0tYy+gLG1eUjBbuG4DKyGO81qh6Xuw@mail.gmail.com>
References: <CANYYVq+PXrNTO-W90UChbJ+FL_h0qoEpJ2zXTVGZj_89P9CyTw@mail.gmail.com>
	<2b31f655c7696125284523fa06695429f24d79f8.camel@cybertec.at>
	<be86101e-fe5e-0edf-620a-78c16fbb0d17@gmail.com>
	<CANYYVqKrU=8gxLU_5=zd0tYy+gLG1eUjBbuG4DKyGO81qh6Xuw@mail.gmail.com>

On Fri, 2018-12-14 at 14:21 +0200, Artem Tomyuk wrote:
> пт, 14 дек. 2018 г. в 14:14, Ron <ronljohnsonjr@gmail.com>:
> > On 12/14/2018 05:29 AM, Laurenz Albe wrote:
> > > Artem Tomyuk wrote:
> > >> Why autovacuum cant delete those rows?
> > > Either long running transactions (check pg_stat_activity)
> > > or prepared transactions (check pg_prepared_xacts)
> > > or stale replication slots (check pg_replication_slots).
> > 
> > Would a manual "VACUUM FULL pg_attribute;" solve the problem?
>
> yes, it helps

Only if the problems have been removed.
Otherwise, VACUUM (FULL) won't help.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com





view thread (6+ messages)  latest in thread

Message-ID: <c742bb3b991357b9aba06b3985630e0e9372fed2.camel@cybertec.at>
Permalink:  ../c742bb3b991357b9aba06b3985630e0e9372fed2.camel@cybertec.at/
Also on:    postgresql.org/message-id/c742bb3b991357b9aba06b3985630e0e9372fed2.camel@cybertec.at

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, admin@leboutique.com, ronljohnsonjr@gmail.com
  Subject: Re: pg_attribute getting bloated in size
  In-Reply-To: <c742bb3b991357b9aba06b3985630e0e9372fed2.camel@cybertec.at>
  References: <CANYYVq+PXrNTO-W90UChbJ+FL_h0qoEpJ2zXTVGZj_89P9CyTw@mail.gmail.com> <2b31f655c7696125284523fa06695429f24d79f8.camel@cybertec.at> <be86101e-fe5e-0edf-620a-78c16fbb0d17@gmail.com> <CANYYVqKrU=8gxLU_5=zd0tYy+gLG1eUjBbuG4DKyGO81qh6Xuw@mail.gmail.com> <c742bb3b991357b9aba06b3985630e0e9372fed2.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