Re: Nested Loop WAS: VACUUM ANALYZE makes things worse!

Поиск
Список
Период
Сортировка
Искать

Re: Nested Loop WAS: VACUUM ANALYZE makes things worse!

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Ian Harding"  writes:
> 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?

I notice that in the "before" state, the planner thinks there will be
some thousands of rows coming out of each join, but in the "after"
state only one row.  Which of these is more correct?  (If you are
running 7.2, it'd be helpful to show EXPLAIN ANALYZE not just
EXPLAIN results for each case.)

			regards, tom lane

Nested Loop WAS: VACUUM ANALYZE makes things worse!

От:
"Ian Harding" <ianh@tpchd.org>
Дата:
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
FAQ