"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > I had previously mentioned that queries run much different depending on > whether a VACUUM ANALYZE is done or just a plain ANALYZE.
The problem appears to be that it's picking the wrong index to use for the second part of the query (the certrans_active = 'f' part). You have not shown us enough info to guess why though. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings