Re: Autovacuum of pg_shdepend

From: Ondřej Světlík <osvetlik(at)flexibee(dot)eu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum of pg_shdepend
Date: 2016-05-04 19:12:02
Message-ID: 572A4982.7080209@flexibee.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I hit the same issue when we've migrated out all large objects (~200Gb
> total), I've executed `vacuumlo` and then all autovacuums started to
> process `pg_shdepend`.
> They've been picking on this table over and over again from different
> databases, but were stopping on the truncation phase due to other
> autovacuums were waiting on the same table.
>
> I ended up manually vacuuming this table in the database, that was
> cleaned up, and also in the `postgres` DB. It fixed the case for me.
> This was on 9.0.23 though.
>
> --
> Victor Y. Yegorov

Thank you very much, Victor, I am going to try your solution. In fact,
I'm already trying :-).

With regards,

Ondřej

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ondřej Světlík 2016-05-04 20:08:25 Re: Autovacuum of pg_shdepend
Previous Message Ondřej Světlík 2016-05-04 19:09:07 Re: Autovacuum of pg_shdepend