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
