Re: Strange slow database

David Mitchell <david(dot)mitchell(at)telogis(dot)com> 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