OIDs / noOIDs tables?

Поиск
Список
Период
Сортировка
От Heni Lolov
Тема OIDs / noOIDs tables?
Дата
Msg-id 20020311161024.82537.qmail@web21003.mail.yahoo.com
обсуждение исходный текст
Ответы Re: OIDs / noOIDs tables?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: OIDs / noOIDs tables?  (Peter Eisentraut <peter_e@gmx.net>)
Re: OIDs / noOIDs tables?  (Mathieu Arnold <mat@mat.cc>)
Список pgsql-admin
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).

Can anybody tell me why?
Thanks in advance!

regards, hal

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/

В списке pgsql-admin по дате отправления:

Предыдущее
От: Robert.Farrugia@go.com.mt
Дата:
Сообщение: Difference between VARCHARs
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: One sequence for different tables