Re: BUG #3657: Performance leaks when using between of two equal dates - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #3657: Performance leaks when using between of two equal dates
Date
Msg-id 470A0CA5.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: BUG #3657: Performance leaks when using between of two equal dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #3657: Performance leaks when using between of two equal dates
List 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 by date:

Previous
From: "Michael Enke"
Date:
Subject: BUG #3659: should use implizit type cast in check constraint
Next
From: Tom Lane
Date:
Subject: Re: BUG #3659: should use implizit type cast in check constraint