Re: Nested Loop WAS: VACUUM ANALYZE makes things

<heavy sigh> I meant enable_nestloop.... It seems the Merge Join the optimizer came up with before vacuum analyze was
theright answer in this case. 

>>> "Ian Harding" <ianh@tpchd.org> 04/12/02 01:43PM >>>
Doh!  I set enable_seqscan = off and things are snappy again.

Same problem though, how can I fix the query so the optimizer comes to the same conclusion?

Thanks,

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster