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   [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to