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

From Jim C. Nasby
Subject Re: left join performance problem
Date
Msg-id 20030616003629.T66185@flake.decibel.org
Whole thread Raw
In response to Re: left join performance problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: left join performance problem
Re: left join performance problem
List pgsql-performance
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.

*wipes egg off face*
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Partial index where clause not filtering through
Next
From: Tom Lane
Date:
Subject: Re: Partial index where clause not filtering through