Re: using hash index when BETWEEN is specified

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Asko Oja" <ascoja(at)gmail(dot)com>
Cc: "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: using hash index when BETWEEN is specified
Date: 2008-09-10 11:13:46
Message-ID: 603c8f070809100413s63354e5fk87d359ef2adee918@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2008-09-10 12:11:43 Base64 decode/encode performance
Previous Message Asko Oja 2008-09-10 10:52:19 Re: using hash index when BETWEEN is specified