Re: VACUUM FULL fails to free diskspacef

Morten Guldager wrote:
> 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)

That is interesting.  I originally thought maybe the indexes aren't
truncated, but it looks like that is happening.  Please try
/contrib/oid2name to find which files are taking the space.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073