Обсуждение: ...

Поиск
Список
Период
Сортировка

...

От
"abremond@voila.fr"
Дата:
Hi,
I manage several databases PostgreSQL 7.3.1 and I have noticed a problem. 
When I delete many rows (with OID) the free space of disk doesn't changed !
I make a vacuumdb, but I doesn't notice an increase of the free space disk.
In a last step, I make a backup and a restoration but, it's the same.

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

I would like to upgrade in PostgreSQL 7.3.2, and I would like to know if this problem exist in this release ?

Best regards.

Annie.

------------------------------------------

Faites un voeu et puis Voila ! www.voila.fr

Re:

От
"A.Bhuvaneswaran"
Дата:
> I manage several databases PostgreSQL 7.3.1 and I have noticed a problem.
> When I delete many rows (with OID) the free space of disk doesn't changed !
> I make a vacuumdb, but I doesn't notice an increase of the free space disk.
> In a last step, I make a backup and a restoration but, it's the same.

vacuum full must help you.

regards,
bhuvaneswaran