Re: oid wraparound

Thanks, Neil.

> Hubert Fröhlich wrote:
>
>> 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?
>
>
> With the default settings, there is exactly the same risk of OID
> wraparound as in earlier releases. However, you can set the
> "default_with_oids" configuration parameter to false to significantly
> reduce OID consumption, to the point that you probably won't need to
> worry about it. It will mean that tables will not have OIDs by default,
> so you should specify WITH OIDS when creating tables that need OIDs if
> necessary (although think twice before doing this, as there are only a
> few good reasons to use OIDs in user tables).

What good reasons to use OIDs in user tables are still left?
  * For speeding up  some special types of queries?

--
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