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>)
Список pgsql-general
On Fri,  4 Apr 2003 09:23:12 +0200, "abremond@voila.fr"
<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