Bruno Wolff III <[EMAIL PROTECTED]> writes:
>   Hans-Jürgen Schönig <[EMAIL PROTECTED]> 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

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to