Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I find out the space used on disk for a table/index - Mailing list pgsql-general

From Craig Ringer
Subject Re: How can I find out the space used on disk for a table/index
Date
Msg-id 1247551309.22064.16.camel@ayaki
Whole thread Raw
In response to Re: How can I find out the space used on disk for a table/index  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
On Mon, 2009-07-13 at 00:53 +0100, Greg Stark wrote:

> Also counter-productive since vacuum full actually causes indexes to
> grow, not shrink.

As a result, your indexes may be quite bloated. Consider REINDEXing them
to get them back to sensible sizes, then avoiding VACUUM FULL.

--
Craig Ringer

pgsql-general by date:

Previous
From: "V S P"
Date:
Subject: [Q] single image Table across multiple PG servers
Next
From: Simon Riggs
Date:
Subject: Re: Checkpoint Tuning Question