Re: pg_attribute getting bloated in size

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_attribute getting bloated in size
Date: 2018-12-14 12:13:49
Message-ID: be86101e-fe5e-0edf-620a-78c16fbb0d17@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Artem Tomyuk 2018-12-14 12:21:50 Re: pg_attribute getting bloated in size
Previous Message Laurenz Albe 2018-12-14 11:29:00 Re: pg_attribute getting bloated in size