Richard A Lough <ralough(dot)ced(at)dnet(dot)co(dot)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
In response to
pgsql-novice by date
|Next:||From: Doug Silver||Date: 2002-03-20 22:14:08|
|Subject: perl/DBI transaction rollback of sequences|
|Previous:||From: Richard A Lough||Date: 2002-03-20 21:34:31|
|Subject: Re: Estimating Database Disk Space|