Re: template0 needing vacuum freeze? - Mailing list pgsql-general

From Don Seiler
Subject Re: template0 needing vacuum freeze?
Date
Msg-id CAHJZqBAXw_JR+mPG7CJ8t-Ya7R2V4zzRQ6Mo-Jki_Xu-WLJn6g@mail.gmail.com
Whole thread Raw
In response to Re: template0 needing vacuum freeze?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: template0 needing vacuum freeze?
Next
From: Adrian Klaver
Date:
Subject: Re: template0 needing vacuum freeze?