Re: Rapidly decaying performance repopulating a large table

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 gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD