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
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 |