Re: Freezing without write I/O - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Freezing without write I/O
Date
Msg-id 20130530210611.GC4715@momjian.us
Whole thread Raw
In response to Freezing without write I/O  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: Freezing without write I/O  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On Thu, May 30, 2013 at 04:33:50PM +0300, Heikki Linnakangas wrote:
> This would also be the first step in allowing the clog to grow
> larger than 2 billion transactions, eliminating the need for
> anti-wraparound freezing altogether. You'd still want to truncate
> the clog eventually, but it would be nice to not be pressed against
> the wall with "run vacuum freeze now, or the system will shut down".

Keep in mind that autovacuum_freeze_max_age is 200M to allow faster clog
truncation.  Does this help that?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Vacuum, Freeze and Analyze: the big picture
Next
From: Amit Langote
Date:
Subject: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries