David Mitchell <david.mitchell@xxxxxxxxxxx> writes: > I dumped and loaded then wrote a script to compare the sizes of tables. > I noticed that a few of the indexes, especially the indexes on the > 15million table shrunk a lot (~50% reduction - ~400Mb). Also, the > pg_attribute_relid_attnam_index index shrank loads, to 1% of its > original size. Hm, better check whether your vacuuming policy is taking care of the system catalogs ... > From this, we tried reindexing indexes and found we got > the same reduction in index size. Strangely though, our queries appear > to have sped up not just on the servers we reindexed, but across the > whole cluster - so apparently something else is affecting the speed of > this all, not just bloat. Odd indeed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
