Re: pg_attribute getting bloated in size

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_attribute getting bloated in size
Date: 2018-12-14 12:21:50
Message-ID: CANYYVqKrU=8gxLU_5=zd0tYy+gLG1eUjBbuG4DKyGO81qh6Xuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

yes, it helps

пт, 14 дек. 2018 г. в 14:14, Ron <ronljohnsonjr(at)gmail(dot)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?
>
> --
> Angular momentum makes the world go 'round.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-12-14 14:33:32 Re: pg_attribute getting bloated in size
Previous Message Ron 2018-12-14 12:13:49 Re: pg_attribute getting bloated in size