Problem to manage OID on the space disk

From: abremond(at)voila(dot)fr <abremond(at)voila(dot)fr>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Problem to manage OID on the space disk
Date: 2003-04-04 07:23:12
Message-ID: HCT5UO$2E3B67977E3D8DC9744E734E8D8025EF@voila.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Steffen 2003-04-04 08:08:50 feature request - adding columns with default value
Previous Message Thomas Beutin 2003-04-04 06:33:48 Re: php - postgreSQL link module