Postgres Pro
Downloads
Home   >   mailing lists

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

From Viktor Rosenfeld
Subject How can I find out the space used on disk for a table/index
Date
Msg-id E59DCEC4-250D-40E9-BC4A-3FD0C97E2510@informatik.hu-berlin.de
Whole thread Raw
Responses Re: How can I find out the space used on disk for a table/index
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "IVO GELOV"
Date:
Subject: Rule acting as REPLACE INTO behave strange
Next
From: Ms swati chande
Date:
Subject: Could not Start Server (could not create any TCP/IP sockets)