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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
