| From: | Morten Guldager <mogul(at)uni2(dot)dk> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | VACUUM FULL fails to free diskspace |
| Date: | 2002-10-16 13:01:56 |
| Message-ID: | Pine.LNX.4.44.0210161453090.25978-100000@guldager.uni.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
Even when I drop the database the diskspace stayes allocated.
/Morten %-)
----------------------------------------------------------------
Morten(dot)Guldager(at)uni2(dot)dk Sysadm @ Tele2 Denmark +45 7730 1164
----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Boes | 2002-10-16 13:42:02 | Re: Tools / Monitoring |
| Previous Message | Denis Braekhus | 2002-10-16 08:40:27 | Tools / Monitoring |