Re: using hash index when BETWEEN is specified

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: using hash index when BETWEEN is specified
Дата
Msg-id 1221049533.22946.1.camel@huvostro
обсуждение исходный текст
Ответ на Re: using hash index when BETWEEN is specified  ("Robert Haas" <robertmhaas@gmail.com>)
Ответы Re: using hash index when BETWEEN is specified
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Base64 decode/encode performance
Следующее
От: Aidan Van Dyk
Дата:
Сообщение: Re: Synchronous Log Shipping Replication