"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

Reply via email to