Re: OIDs / noOIDs tables?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: OIDs / noOIDs tables?
Дата
Msg-id Pine.LNX.4.30.0203111422010.690-100000@peter.localdomain
обсуждение исходный текст
Ответ на OIDs / noOIDs tables?  (Heni Lolov <hal_bg@yahoo.com>)
Список pgsql-admin
Heni Lolov writes:

> 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.

Did you actually change the CREATE TABLE commands to say WITHOUT OIDS?  By
default, OID columns are still created.

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: OIDs / noOIDs tables?
Следующее
От: Björn Lundin
Дата:
Сообщение: News server broken ?