Re: Problem to manage OID on the space disk - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Problem to manage OID on the space disk
Date
Msg-id 00f39vce04emaunkt1dt8guqsskvl28ghf@4ax.com
Whole thread Raw
In response to Problem to manage OID on the space disk  ("abremond@voila.fr" <abremond@voila.fr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: psql in shell
Next
From: Jan Wieck
Date:
Subject: Re: psql in shell