Re: "Constraint exclusion" is not general enough - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: "Constraint exclusion" is not general enough
Date
Msg-id 1154973425.848.120.camel@home
Whole thread Raw
In response to Re: "Constraint exclusion" is not general enough  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 2006-08-07 at 13:44 -0400, Tom Lane wrote:
> Rod Taylor <pg@rbt.ca> writes:
> > A simple way of doing this might be to use a minimum cost number?
> 
> But you don't have any cost numbers until after you've done the plan.

Isn't it possible to find the cost using the straight forward (fast)
method, find out what order of magnitude it is in, then do a second pass
with additional planner bells and whistles turned on if the first plan
had a high estimate?

-- 



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Another Ltree/GiST problem
Next
From: Tom Lane
Date:
Subject: Re: buildfarm - make check failures for leveret on 8.0 and 8.1