David Blewett <david@xxxxxxxxxxxxxxxx> writes: > On Thu, May 7, 2009 at 12:53 PM, David Blewett <david@xxxxxxxxxxxxxxxx> wrote: >> 1. http://dpaste.com/hold/41842/ >> 2. http://explain.depesz.com/s/Wg >> 3. http://explain.depesz.com/s/1s >> 4. http://dpaste.com/hold/41846/ > Forgot to mention that I'm using Postgres 8.3.6 on linux 2.6.24. Well, the reason it likes the nestloop plan is the estimate of just one row out of the lower joins --- that case is pretty much always going to favor a nestloop over other kinds of joins. If it were estimating even as few as ten rows out, it'd likely switch to a different plan. So the question to ask is why the rowcount estimates are so abysmally bad. You mentioned having tried to increase the stats targets, but without seeing the actual stats data it's hard to speculate about this. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
