On Tue, 22 Apr 2008, David Wilson wrote:

Is there a way to get the size of a specific index, on that note?

select pg_size_pretty(pg_relation_size('index_name')) works for me.

There's a neat article on other things you can look at like this at http://andreas.scherbaum.la/blog/archives/282-table-size,-database-size.html

--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to