VACUUM FULL fails to free diskspace
VACUUM FULL fails to free diskspace
От:
Morten Guldager <mogul@uni2.dk>
Дата:
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 ----------------------------------------------------------------