Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Stark
Subject Re: Freezing without write I/O
Date
Msg-id CAM-w4HPpRbcJeNrcAVPrGNUTwwSDU0kHZy9erroJsLDbhO3rKQ@mail.gmail.com
Whole thread Raw
In response to Re: Freezing without write I/O  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Freezing without write I/O  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
Tree view 
On Fri, May 31, 2013 at 3:04 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Even at a more modest 10,000 tps, with default
> settings, you'll do anti-wraparound vacuums of the entire cluster
> about every 8 hours.  That's not fun.

I've forgotten now. What happens if you have a long-lived transaction
still alive from > 2B xid ago?


-- 
greg

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Redesigning checkpoint_segments
Next
From: Kevin Grittner
Date:
Subject: Re: Redesigning checkpoint_segments