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)
Even when I drop the database the diskspace stayes allocated.
/Morten %-)
----------------------------------------------------------------
Morten.Guldager@uni2.dk Sysadm @ Tele2 Denmark +45 7730 1164
----------------------------------------------------------------