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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Tiago Daniel Jacobs" <tiago(at)mdtestudio(dot)com(dot)br>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3657: Performance leaks when using between of two equal dates
Date: 2007-10-08 15:55:33
Message-ID: 470A0CA5.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>> On Sat, Oct 6, 2007 at 11:28 AM, in message <24828(dot)1191688097(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I've been wondering
> if it would be worth the trouble to introduce scalarlesel and
> scalargesel estimators ...

FWIW, this is an issue we ran into:

http://archives.postgresql.org/pgsql-performance/2006-03/msg00211.php

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.

-Kevin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-10-08 15:57:40 Re: BUG #3659: should use implizit type cast in check constraint
Previous Message Michael Enke 2007-10-08 15:04:36 BUG #3659: should use implizit type cast in check constraint