I have a query  that Postgres is insisting on using a Nested Loop
for some reason when a Hash Join is much faster. It seems like the
estimates are way off. I've set default_statistics_target to 250, 500,
1000 and analyzed, but they never seem to improve. If I disable
nestloops, the query completes in around 3-5s. With them enabled, it
takes anywhere from 45 to 60 seconds. Here is the DDL for the tables
and the month_last_day function .
Any help would be appreciated!
pgsql-performance by date
|Next:||From: David Blewett||Date: 2009-05-07 17:28:14|
|Subject: Re: Bad Plan for Questionnaire-Type Query|
|Previous:||From: Nikolas Everett||Date: 2009-05-07 15:37:52|
|Subject: Re: Slow select performance despite seemingly reasonable query plan|