Re: Slow index

Matthew Wakeling <matthew@flymine.org> writes:
> Hi all. I'm having an interesting time performance-wise with a set of indexes.
> Any clues as to what is going on or tips to fix it would be appreciated.

Are the indexed columns all the same datatype?  (And which type is it?)

It might be helpful to REINDEX the "slow" index.  It's possible that
what you're seeing is the result of a chance imbalance in the btree,
which reindexing would fix.

            regards, tom lane