Re: WAL-based allocation of XIDs is insecure - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WAL-based allocation of XIDs is insecure
Date
Msg-id 20587.983824177@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL-based allocation of XIDs is insecure  (Ian Lance Taylor <ian@airs.com>)
List pgsql-hackers
Ian Lance Taylor <ian@airs.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Up through 7.0, Postgres allocated XIDs a thousand at a time, and not
>> only did the not-yet-used XIDs get lost in a crash, they'd get lost in
>> a normal shutdown too.  What I propose will waste XIDs in a crash but
>> not in a normal shutdown, so it's still an improvement over prior
>> versions as far as XID consumption goes.

> I find this somewhat troubling, since I like to think in terms of
> long-running systems--like, decades.  But I guess it's OK (for me) if
> it is fixed in the next couple of years.

Agreed, we need to do something about the XID-wrap problem pretty soon.
But we're not solving it for 7.1, and in the meantime I don't think
these changes make much difference either way.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Ian Lance Taylor
Date:
Subject: Re: WAL-based allocation of XIDs is insecure
Next
From: Peter Eisentraut
Date:
Subject: pg_restore -U