No title

Started by abremond@voila.frabout 23 years ago2 messagesbugs
Jump to latest
#1abremond@voila.fr
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

#2A.Bhuvaneswaran
bhuvansql@myrealbox.com
In reply to: abremond@voila.fr (#1)
Re:

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