Re: Estimating Database Disk Space

Richard A Lough <ralough.ced@dnet.co.uk> writes:
> Only one of my active databases
> shows significant figures (recently increased):

> relpages | relname
> 17473    pg_attribute_relid_attnam_index
> 7267    pg_attribute_relid_attnum_index
> 3245    pg_attribute

Yipes ... you must do a lot of table creation and deletion.

The index bloat here is a known result of inefficiency in vacuuming
indexes (there's no good way to reclaim index pages at the moment).
You could probably fix it by REINDEXing pg_attribute, but it might
be easier to just dump, dropdb, createdb, reload that database.

Yes, there's a TODO item to improve index vacuuming ...

            regards, tom lane