Evgeny Shishkin <itparanoia@xxxxxxxxx> writes: > On Dec 14, 2012, at 3:09 AM, Andrew Dunstan <andrew@xxxxxxxxxxxx> wrote: >> Well, it looks like it's choosing a join order that's quite a bit different from the way the query is expressed, so the OP might need to play around with forcing the join order some. > OP joins 8 tables, and i suppose join collapse limit is set to default 8. I thought postgresql's optimiser is not mysql's. It's not obvious to me that there's anything very wrong with the plan. An 8-way join that produces 150K rows is unlikely to run in milliseconds no matter what the plan. The planner would possibly have done the last join step differently if it had had a better rowcount estimate, but even if that were free the query would still have been 7 seconds (vs 8.5). 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
