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