Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption?
Дата
Msg-id 1136.1509634663@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation -DB Corruption?  (Arjun Ranade <ranade@nodalexchange.com>)
Ответы Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation -DB Corruption?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-admin
Arjun Ranade <ranade@nodalexchange.com> writes:
> After dropping the replication slot, VACUUM FULL runs fine now and no
> longer reports the "oldest xmin is far in the past"

Excellent.  Maybe we should think about providing better tools to notice
"stuck" replication slots.

In the meantime, you probably realize this already, but if global xmin
has been stuck for months then you're going to have terrible bloat
everywhere.  Database-wide VACUUM FULL seems called for.
        regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: Arjun Ranade
Дата:
Сообщение: Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation -DB Corruption?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [ADMIN] Missing Chunk Error when doing a VACUUM FULL operation -DB Corruption?