| 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: | Whole Thread | Raw Message | 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 |