David Mitchell <david.mitchell@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
