Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> Hans-Jrgen Schnig <postgres(at)cybertec(dot)at> wrote:
>> I have a join across 10 tables + 2 subselects across 4 tables
>> on the machine I use for testing:
>> planner: 12 seconds
>> executor: 1 second
> One option you have is to explicitly give the join order.
Yes, this is exactly the sort of situation where forcing the join order
is a big performance win. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html
regards, tom lane