Re: Altering existing table to be WITHOUT OIDs - Mailing list pgsql-general

From Doug Fields
Subject Re: Altering existing table to be WITHOUT OIDs
Date
Msg-id 5.1.0.14.2.20020524150206.02c27d88@mail.pexicom.com
Whole thread Raw
In response to Re: Altering existing table to be WITHOUT OIDs  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
>I don't know of a way. However, keep in mind that WITHOUT OIDS is not
>(currently) a storage optimization -- the OID field is still stored on disk.
>The WITHOUT OIDS option is primarily for people who might be in danger
>of OID-wraparound.

Thanks. Yes, I am aware that it is not a storage optimization; however, I
may be adding 25 million + records to some tables each day, and this will
quickly wrap any 31 or 32 bit number. I actually use OIDs on one table as a
pkey (really a way to attempt the enforcing of a UNIQUE constraint without
the overhead of a 4 or 5 column index) and don't want them wrapping.

Cheers,

Doug



pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: Case Insensitive Data Type
Next
From: Doug Fields
Date:
Subject: Re: Efficiency question: VARCHAR with empty string