Thread: 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