Re: Strange slow database

David Mitchell <david.mitchell@telogis.com> writes:
> 18/11/2005 03:02:29 INFO:  index "pg_attribute_relid_attnam_index" now
> contains 2861 row versions in 11900 pages
> 18/11/2005 03:02:29 DETAIL:  11834 index pages have been deleted, 11834
> are currently reusable.

> 18/11/2005 03:02:30 INFO:  index "pg_attribute_relid_attnum_index" now
> contains 2861 row versions in 2942 pages
> 18/11/2005 03:02:30 DETAIL:  2917 index pages have been deleted, 2917
> are currently reusable.

> 18/11/2005 03:02:30 INFO:  "pg_attribute": found 0 removable, 2861
> nonremovable row versions in 48 pages

Those indexes are pretty bloated :-( but pg_attribute itself seems to be
nice and tight.  I speculate that you did a VACUUM FULL on it recently.

The condition of the indexes suggests strongly that you've not been
vacuuming pg_attribute often enough (and perhaps not any of the other
system catalogs, either?).  Heavy use of temp tables will cause
pg_attribute and pg_class to bloat if you don't keep after them.

At the moment, a REINDEX seems to be indicated.

            regards, tom lane