Postgres Pro
Downloads
Home   >   mailing lists

Nested Loop WAS: VACUUM ANALYZE makes things worse! - Mailing list pgsql-general

From Ian Harding
Subject Nested Loop WAS: VACUUM ANALYZE makes things worse!
Date
Msg-id scb6e4d7.086@mail.tpchd.org
Whole thread Raw
Responses Re: Nested Loop WAS: VACUUM ANALYZE makes things worse!
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: VACUUM ANALYZE makes things worse!
Next
From: Tom Lane
Date:
Subject: Re: Critical performance problems on large databases