Re: Lazy xid assignment V3

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Lazy xid assignment V3
Date: 2007-09-03 12:37:24
Message-ID: 20070903123724.GD4998@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Marko Kreen 2007-09-03 12:53:44 Re: Lazy xid assignment V3
Previous Message Heikki Linnakangas 2007-09-03 11:46:10 tsearch refactorings