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 http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
