Re: OIDs / noOIDs tables?

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