Re: template0 needing vacuum freeze?

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: template0 needing vacuum freeze?
Дата
Msg-id CAHJZqBAXw_JR+mPG7CJ8t-Ya7R2V4zzRQ6Mo-Jki_Xu-WLJn6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: template0 needing vacuum freeze?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, May 18, 2020 at 8:51 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Do you have an idea why autovac was failing to clear the issue on that one
problem table, though?

Before I intervened, the maintenance_work_mem was only 16MB (they had encoded and carried over PG 8 defaults in the chef recipe). I bumped it to 512MB before kicking off my freezeThat's the big factor I can think of. This is a huge table obviously as well. By the time it caught my attention there were 850M dead tuples to be cleaned up. My VACUUM FREEZE has been running just just about 5 days and is probably half way done. We shouldn't be at risk of hitting wraparound though (only 52% there).

Don.

--
Don Seiler
www.seiler.us

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: template0 needing vacuum freeze?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: template0 needing vacuum freeze?