Re: pg_attribute getting bloated in size - Mailing list pgsql-admin

From Ron
Subject Re: pg_attribute getting bloated in size
Date
Msg-id be86101e-fe5e-0edf-620a-78c16fbb0d17@gmail.com
Whole thread Raw
In response to Re: pg_attribute getting bloated in size  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: pg_attribute getting bloated in size  (Artem Tomyuk <admin@leboutique.com>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_attribute getting bloated in size
Next
From: Artem Tomyuk
Date:
Subject: Re: pg_attribute getting bloated in size