Postgres Pro
Downloads
Home   >   mailing lists

Re: LEFT JOINs takes forever...almost. - Mailing list pgsql-admin

From Tom Lane
Subject Re: LEFT JOINs takes forever...almost.
Date
Msg-id 26720.1032015575@sss.pgh.pa.us
Whole thread Raw
In response to LEFT JOINs takes forever...almost.  ("Niclas Gustafsson" <niclas.gustafsson@codesense.com>)
List pgsql-admin
Tree view 
"Niclas Gustafsson" <niclas.gustafsson@codesense.com> writes:
> Can someone please explain why the first query is 3000 times slower?
> Surely there must be a any way to speed it up?

You're forcing a poor join order.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html

            regards, tom lane

pgsql-admin by date:

Previous
From: "shreedhar"
Date:
Subject: Is it possible to get the return value of trigger function using PHP or any other method.
Next
From: Adam Witney
Date:
Subject: Problem starting postmaster