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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026