Re: join removal - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: join removal
Date
Msg-id 1269793491.3684.2640.camel@ebony
Whole thread Raw
In response to Re: join removal  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: join removal
List pgsql-hackers
On Sun, 2010-03-28 at 02:15 -0400, Tom Lane wrote:
> I wrote:
> > [ crude patch ]
> 
> Oh, btw, if you try to run the regression test additions in that patch
> against CVS HEAD, you'll find out that HEAD actually fails to optimize
> the two-levels-of-removable-joins case.  Seems like another reason to
> press ahead with making the change.

Yes, please.

Does the new patch find more than two levels of join removal?

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: join removal
Next
From: Simon Riggs
Date:
Subject: Re: More idle thoughts