Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: using hash index when BETWEEN is specified
Date
Msg-id 603c8f070809100413s63354e5fk87d359ef2adee918@mail.gmail.com
Whole thread Raw
In response to Re: using hash index when BETWEEN is specified  ("Asko Oja" <ascoja@gmail.com>)
Responses Re: using hash index when BETWEEN is specified  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
>> 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?

...Robert

pgsql-hackers by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: using hash index when BETWEEN is specified
Next
From: Gaetano Mendola
Date:
Subject: Base64 decode/encode performance