Problem to manage OID on the space disk
Hi,
I manage several databases PostgreSQL 7.3.1 (on Linux RedHat 6.2) 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 ?
Thank you for your help.
Best regards.
Annie.
------------------------------------------
Faites un voeu et puis Voila ! www.voila.fr
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