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

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

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
I`m sorry, but why work around?<br>
<br>
The overhead of "99%" of cases is so bigger? What about an "option"
like constraint exclusion...<br>
<br>
I've worked around also, but would like to see this topic in a TODO or
further implementation.<br>
<br>
Thanks by patience.<br>
<br>
<br>
<br>
Kevin Grittner escreveu:
<blockquote cite="mid:470A0CA5(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov" type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">On Sat, Oct 6, 2007 at 11:28 AM, in message <a class="moz-txt-link-rfc2396E" href="mailto:24828(dot)1191688097(at)sss(dot)pgh(dot)pa(dot)us">&lt;24828(dot)1191688097(at)sss(dot)pgh(dot)pa(dot)us&gt;</a>,
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->Tom Lane <a class="moz-txt-link-rfc2396E" href="mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us">&lt;tgl(at)sss(dot)pgh(dot)pa(dot)us&gt;</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I've been wondering
if it would be worth the trouble to introduce scalarlesel and
scalargesel estimators ...
</pre>
</blockquote>
<pre wrap=""><!---->
FWIW, this is an issue we ran into:

<a class="moz-txt-link-freetext" href="http://archives.postgresql.org/pgsql-performance/2006-03/msg00211.php">http://archives.postgresql.org/pgsql-performance/2006-03/msg00211.php</a>

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

</pre>
</blockquote>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Reiss 2007-10-09 11:53:17 BUG #3660: unused empty file is created with csvlog
Previous Message Bruce Momjian 2007-10-08 18:01:30 Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field