From: | Hubert Fröhlich <hubert(dot)froehlich(at)bvv(dot)bayern(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | oid wraparound |
Date: | 2005-04-26 09:24:31 |
Message-ID: | 426E08CF.9070300@bvv.bayern.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
some time ago, there was a discussion about oid wraparound. See
http://archives.postgresql.org/pgsql-general/2002-10/msg00561.php .
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful
oids approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look like? Where do I have to
be careful:
OID > 2billion? 4billion?
What about the danger of TID wraparounds? (databases are VACUUMed regularly)
--
Mit freundlichen Grüßen / With kind regards
Hubert Fröhlich
-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Bezirksfinanzdirektion München
Alexandrastr. 3, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2190 - 2980
Fax :+49 (0)89 / 2190 - 2997
hubert dot froehlich at bvv dot bayern dot de
From | Date | Subject | |
---|---|---|---|
Next Message | Jake Stride | 2005-04-26 09:47:08 | Intervals |
Previous Message | Marco Colombo | 2005-04-26 09:11:09 | Re: Postgres source (tar file) for Fedora Core OS? |