Re: Determining dead/unused space in a table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Spadea <david(dot)spadea(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Determining dead/unused space in a table?
Date: 2009-10-18 15:53:17
Message-ID: 6823.1255881197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Spadea <david(dot)spadea(at)gmail(dot)com> writes:
> I'm looking to do some reporting on tablespace usage, and wanted to be able
> to determine how much of the space a table physically occupies is actually
> in use.

contrib/pgstattuple can help you with this.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-10-18 16:00:55 Re: How ad an increasing index to a query result?
Previous Message David Spadea 2009-10-18 11:11:21 Determining dead/unused space in a table?