Re: OIDs / noOIDs tables? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: OIDs / noOIDs tables?
Date
Msg-id Pine.LNX.4.30.0203111422010.690-100000@peter.localdomain
Whole thread Raw
In response to OIDs / noOIDs tables?  (Heni Lolov <hal_bg@yahoo.com>)
List pgsql-admin
Heni Lolov writes:

> As for version 7.2 postgres supports tables wothout OID. So I have 10 Gb
> database and I would like to upgrade it to 7.2 to make the tables without oids
> in order to  save disc space. I made a test. I created one table with oids and
> another without oids and dumped the same data in both of them but there was no
> difference in table sizes.

Did you actually change the CREATE TABLE commands to say WITHOUT OIDS?  By
default, OID columns are still created.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: OIDs / noOIDs tables?
Next
From: Björn Lundin
Date:
Subject: News server broken ?