Re: using hash index when BETWEEN is specified - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: using hash index when BETWEEN is specified
Date
Msg-id 1221049533.22946.1.camel@huvostro
Whole thread Raw
In response to Re: using hash index when BETWEEN is specified  ("Robert Haas" <robertmhaas@gmail.com>)
Responses Re: using hash index when BETWEEN is specified  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-hackers
On Wed, 2008-09-10 at 07:13 -0400, Robert Haas wrote:
> >> I'm not planner guru but it seems to me that BETWEEN clause could be
> >> rewritten as a IN clause for integer data types and small interval.
> >
> > Where should the line be drawn.
> > Define small :)
> 
> When the estimated cost is lower?

You still need to draw a line for when to even try estimating the cost .

Will this be interval of 10 ? or 100 ? or 10000 ?

----------------
Hannu 



pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Base64 decode/encode performance
Next
From: Aidan Van Dyk
Date:
Subject: Re: Synchronous Log Shipping Replication