Nested Loop WAS: VACUUM ANALYZE makes things worse!

From: "Ian Harding" <ianh(at)tpchd(dot)org>
To: <pgsql-general(at)postgresql(dot)org>, <ianh(at)tpchd(dot)org>
Subject: Nested Loop WAS: VACUUM ANALYZE makes things worse!
Date: 2002-04-12 20:43:18
Message-ID: scb6e4d7.086@mail.tpchd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)tpchd(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-12 20:47:30 Re: Critical performance problems on large databases
Previous Message Ian Harding 2002-04-12 20:33:34 VACUUM ANALYZE makes things worse!