Re: BUG #3657: Performance leaks when using between of two equal dates

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: BUG #3657: Performance leaks when using between of two equal dates
Дата
Msg-id 470A0CA5.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: BUG #3657: Performance leaks when using between of two equal dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #3657: Performance leaks when using between of two equal dates
Список pgsql-bugs
>>> On Sat, Oct 6, 2007 at 11:28 AM, in message <24828.1191688097@sss.pgh.p=
a.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:=20
> I've been wondering
> if it would be worth the trouble to introduce scalarlesel and
> scalargesel estimators ...
=20
FWIW, this is an issue we ran into:
=20
http://archives.postgresql.org/pgsql-performance/2006-03/msg00211.php
=20
We worked around it in our framework by checking for a range with equal
values and converting to an equality test before presenting it to the
database.
=20
-Kevin
=20

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

Предыдущее
От: "Michael Enke"
Дата:
Сообщение: BUG #3659: should use implizit type cast in check constraint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3659: should use implizit type cast in check constraint