Re: Autovacuum of pg_shdepend

Поиск
Список
Период
Сортировка
От Ondřej Světlík
Тема Re: Autovacuum of pg_shdepend
Дата
Msg-id 572A4982.7080209@flexibee.eu
обсуждение исходный текст
Ответ на Re: Autovacuum of pg_shdepend  (Victor Yegorov <vyegorov@gmail.com>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ondřej Světlík
Дата:
Сообщение: Re: Autovacuum of pg_shdepend
Следующее
От: Ondřej Světlík
Дата:
Сообщение: Re: Autovacuum of pg_shdepend