| From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
|---|---|
| To: | Hubert Fröhlich <hubert(dot)froehlich(at)bvv(dot)bayern(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: oid wraparound |
| Date: | 2005-04-26 10:17:30 |
| Message-ID: | 200504262017.30382.mr-russ@pws.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 26 Apr 2005 07:24 pm, Hubert Fröhlich wrote:
> 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)
>
With 8.0 you only need to make sure you do database wide vacuums every 1 billion transactions
or so. If you do that, then there is not problem when the XID (Transaction ID) wraps around.
Postgresql will know which transaction were in the past, and which were in the future.
Regards
Russell Smith.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Gaspar | 2005-04-26 10:22:23 | Re: Intervals |
| Previous Message | Dawid Kuroczko | 2005-04-26 10:15:34 | Re: Intervals |