Re: OIDs / noOIDs tables?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Heni Lolov <hal_bg(at)yahoo(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: OIDs / noOIDs tables?
Date: 2002-03-11 19:22:41
Message-ID: Pine.LNX.4.30.0203111422010.690-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Michel Chabanne 2002-03-11 20:21:58 fsync and -F option
Previous Message Peter Eisentraut 2002-03-11 19:04:43 Re: Difference between VARCHARs