Re: autovacuum not prioritising for-wraparound tables - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: autovacuum not prioritising for-wraparound tables
Date
Msg-id 1359570067.32849.YahooMailNeo@web162901.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: autovacuum not prioritising for-wraparound tables  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: autovacuum not prioritising for-wraparound tables
Re: autovacuum not prioritising for-wraparound tables
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> wrote:

> I can't imagine that anybody with a large database ran pg
> successfully with a small freeze_min_age due to this.

I can't speak to this from personal experience, because at
Wisconsin Courts we found ourselves best served by running a
database VACUUM FREEZE ANALYZE each night during off-peak hours.

> It seems to be broken since the initial introduction of
> freeze_table_age in 6587818542e79012276dcfedb2f97e3522ee5e9b.

> Trivial patch attached.

I didn't see a patch attached.

-Kevin



pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: lazy_vacuum_heap()'s removal of HEAPTUPLE_DEAD tuples
Next
From: Andres Freund
Date:
Subject: Re: autovacuum not prioritising for-wraparound tables