Re: Problem to manage OID on the space disk

Поиск
Список
Период
Сортировка
Искать
От
Manfred Koizar
Тема
Re: Problem to manage OID on the space disk
Дата
Msg-id
00f39vce04emaunkt1dt8guqsskvl28ghf@4ax.com
Ответ на
Список
Дерево обсуждения
Problem to manage OID on the space disk "abremond@voila.fr" <abremond@voila.fr>
Re: Problem to manage OID on the space disk Manfred Koizar <mkoi-pg@aon.at>
On Fri,  4 Apr 2003 09:23:12 +0200, "abremond@voila.fr"
 wrote:
>When I delete many rows (with OID) the free space of disk doesn't changed !

That's to be expected.

>I make a vacuumdb, but I doesn't notice an increase of the free space disk.

VACUUM (vacuumdb) does not free disk space, use VACUUM FULL (vacuumdb
--full) instead.

>In a last step, I make a backup and a restoration but, it's the same.

Strange!  I'm sure I'm missing something ...

>How can I remove the OID on my disk without corrupt my databases ?

Annie,  I don't quite understand whether you want to remove rows or
the oid column.  Can you give an example of what you tried?

Servus
 Manfred

В списке pgsql-general по дате отправления
От: Stephan Szabo
Дата:
Сообщение: Re: psql in shell
От: Jan Wieck
Дата:
Сообщение: Re: psql in shell
FAQ