Re: Lazy xid assignment V3 - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: Lazy xid assignment V3
Date
Msg-id 20070903123724.GD4998@alvh.no-ip.org
Whole thread Raw
In response to Lazy xid assignment V3  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Lazy xid assignment V3  ("Marko Kreen" <markokr@gmail.com>)
List pgsql-patches
Florian G. Pflug wrote:

> Since we didn't really reach an agreement on how xid_age should behave,
> I've reverted it back to the original version. So with this patch,
> xid_age will just force assignment of a xid.

Is this really a good idea?  I'm repeating myself, but a query like

select age(xmin) from bigtable

could accelerate Xid wraparound.  If the server is running close to the
limit it could cause a shutdown to prevent the actual wraparound.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-patches by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: tsearch refactorings
Next
From: "Marko Kreen"
Date:
Subject: Re: Lazy xid assignment V3