Truncating table doesn't bring back (ALL?) used space?

From: "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Truncating table doesn't bring back (ALL?) used space?
Date: 2009-09-06 16:26:56
Message-ID: D1109E8B2FB53A45BDB60F8145905CE903A43D23@wdmyexbe03.my.asia.wdc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a largeish table which according to pg_size_pretty, has an on-disk
size of ~22GB Table size and 12GB index size, approx 55million rows.

When I truncate the table, (I've moved the data somewhere else), I see that
I only gain back ~7GB in the Filesystem space.

What gives?

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Samokhin 2009-09-06 16:38:05 Re: How do I store tables on a remote host?
Previous Message Richard Greenwood 2009-09-06 14:51:31 tsearch synonym dictionary problem