Re: Really poor gist index performance with tstzrange types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Really poor gist index performance with tstzrange types
Дата
Msg-id 22700.1370996034@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Really poor gist index performance with tstzrange types  (Joe Van Dyk <joe@tanga.com>)
Ответы Re: Really poor gist index performance with tstzrange types  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-general
Joe Van Dyk <joe@tanga.com> writes:
> Am I doing something silly? Or is the row-estimation for gist indexes not
> even close in this case?

9.2 didn't have any logic for estimating range << conditions.  I see
reasonable estimates for this case in HEAD, though, presumably thanks
to work by Alexander Korotkov.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Van Dyk
Дата:
Сообщение: Really poor gist index performance with tstzrange types
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Really poor gist index performance with tstzrange types