Skip site navigation (1) Skip section navigation (2)

Re: WAL-based allocation of XIDs is insecure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian Lance Taylor <ian(at)airs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL-based allocation of XIDs is insecure
Date: 2001-03-05 20:29:37
Message-ID: 20587.983824177@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Ian Lance Taylor <ian(at)airs(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-03-05 21:05:31
Subject: Re: [SQL] PL/SQL-to-PL/PgSQL-HOWTO beta Available
Previous:From: Ian Lance TaylorDate: 2001-03-05 20:22:27
Subject: Re: WAL-based allocation of XIDs is insecure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group