Postgres Pro
Downloads
Home   >   mailing lists

Truncating table doesn't bring back (ALL?) used space? - Mailing list pgsql-general

From Ow Mun Heng
Subject Truncating table doesn't bring back (ALL?) used space?
Date
Msg-id D1109E8B2FB53A45BDB60F8145905CE903A43D23@wdmyexbe03.my.asia.wdc.com
Whole thread Raw
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Richard Greenwood
Date:
Subject: tsearch synonym dictionary problem
Next
From: Sergey Samokhin
Date:
Subject: Re: How do I store tables on a remote host?