Re: How can I find out the space used on disk for a table/index

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-general(at)postgresql(dot)org, Viktor Rosenfeld <rosenfel(at)informatik(dot)hu-berlin(dot)de>
Subject: Re: How can I find out the space used on disk for a table/index
Date: 2009-07-14 06:01:49
Message-ID: 1247551309.22064.16.camel@ayaki
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2009-07-14 08:26:30 Re: Checkpoint Tuning Question
Previous Message V S P 2009-07-14 05:16:11 [Q] single image Table across multiple PG servers