David Mitchell <[EMAIL PROTECTED]> 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
