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

From: Viktor Rosenfeld <rosenfel(at)informatik(dot)hu-berlin(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: How can I find out the space used on disk for a table/index
Date: 2009-07-12 19:07:56
Message-ID: E59DCEC4-250D-40E9-BC4A-3FD0C97E2510@informatik.hu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I want to judge the performance gain of additional indexes against the
space they consume on disk. Currently I do a VACUUM FULL ANALYZE and
then take the space used by the base directory and do some
calculations. This is time consuming, error-prone and unreliable.

Is there a quick way to compute the space used on disk by an index (in
MB or blocks) using the statistics tables?

Thanks,
Viktor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-07-12 19:17:50 Re: Postgresql databases as a web service
Previous Message Ms swati chande 2009-07-12 19:03:34 Could not Start Server (could not create any TCP/IP sockets)