Re: IN vs EXISTS equivalence - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: IN vs EXISTS equivalence
Date
Msg-id 1193077831.4319.61.camel@ebony.site
Whole thread Raw
In response to IN vs EXISTS equivalence  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: IN vs EXISTS equivalence
Re: IN vs EXISTS equivalence
List pgsql-hackers
On Mon, 2007-10-22 at 09:31 -0500, Kevin Grittner wrote:
> I've requested this before without response, but I'm asking again
> because it just caused me pain again: could we get a TODO added to
> have the planner recognize equivalent IN and EXISTS constructs and
> have them compete on cost estimates?  I know it's not a trivial
> improvement, but if it's on the list maybe someone will pick it up,
> and I see it as the single biggest weakness in PostgreSQL
> performance.

I'll pick it up as a default unless someone requests they have it from
me.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: modify the PostgreSQL Setup Wizard
Next
From: Simon Riggs
Date:
Subject: Feature Freeze date for 8.4