Richard Frith-Macdonald <[EMAIL PROTECTED]> writes:
> What has confused me is why a query using an empty index should be
> slow, irrespective of the state of the table that the index applies to.
Is it actually empty, or have you just deleted-and-not-yet-vacuumed
all the rows in the index?
I had hoped to see comparative EXPLAIN ANALYZE output for the fast and
slow cases. Maybe when it gets slow again you could redo the explain.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
