VACUUM FULL fails to free diskspace - Mailing list pgsql-admin

From Morten Guldager
Subject VACUUM FULL fails to free diskspace
Date
Msg-id 20021016194613.C5130@linuxine.mogul.dk
Whole thread Raw
Responses Re: VACUUM FULL fails to free diskspacef  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Hi,

My database cluster have one database with one table. (if we don't
count template0 and 1.

My table has 3 collumns, 2 ints and a bytea. 2.5M rows and it consumes
150G diskspace. I have a unique index on the 2 ints.

I did a TRUNCATE on the table, and a VACUUM FULL.

But PostgreSQL-7.2.3 did not return the space to the filesystem. (ext3
on linux)


/Morten %-)

(This message may show up twice if the list-moderator is too fast.
I failed to post from the rigth address the first try :-)

pgsql-admin by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Fast Deletion For Large Tables
Next
From: "Josh Goldberg"
Date:
Subject: Re: Tools / Monitoring