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

From Bruce Momjian
Subject Re: OIDs / noOIDs tables?
Date
Msg-id 200203111900.g2BJ0JZ01764@candle.pha.pa.us
Whole thread Raw
In response to OIDs / noOIDs tables?  (Heni Lolov <hal_bg@yahoo.com>)
List pgsql-admin
Heni Lolov wrote:
> Hi
>
> 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.
> Btw the size is the same as the size of the original table in the previous
> release i use (7.0.3).

Yes, tables are the same size. The only difference is that the oid
counter doesn't increase for INESRTs.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Difference between VARCHARs
Next
From: Peter Eisentraut
Date:
Subject: Re: OIDs / noOIDs tables?