Re: left join performance problem - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: left join performance problem
Date
Msg-id 20030616080718.GB25847@wolff.to
Whole thread Raw
In response to Re: left join performance problem  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-performance
On Mon, Jun 16, 2003 at 00:36:29 -0500,
  "Jim C. Nasby" <jim@nasby.net> wrote:
> On Mon, Jun 16, 2003 at 01:28:26AM -0400, Tom Lane wrote:
> > "Jim C. Nasby" <jim@nasby.net> writes:
> > > Any chance of getting a TODO added that would provide the option of
> > > having the optimizer pick join order when you're using the ANSI join
> > > syntax?
> >
> > No ... because it's already DONE.
>
> DOH, I forgot about the subselect trick. Nevermind.

In 7.4 there is a GUC setting to control this. I believe the default
is to not constrain the join order any more than is necessary to
preserve semantics.

pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: any way to use indexscan to get last X values
Next
From: Manfred Koizar
Date:
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance