Content-Type: multipart/alternative;
 boundary="------------HAyd0tcgDdUcgTVqRtY0dHw0"
Message-ID: <eacf8b06-88ef-4d7e-b324-3034c605b529@gmail.com>
Date: Wed, 18 Mar 2026 11:56:20 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: help debugging an issue with selectivity
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
References: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
 <CAKFQuwakY0c3x=2o=gQ6Cr7jQ=DgE_snL1cHf8Oj+irO1fmjEQ@mail.gmail.com>
 <8e4f0d76-9e77-4819-96f7-cbc64a9d2b5a@gmail.com>
 <602084.1773801455@sss.pgh.pa.us>
Content-Language: en-US
From: Greg Hennessy <greg.hennessy@gmail.com>
In-Reply-To: <602084.1773801455@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/eacf8b06-88ef-4d7e-b324-3034c605b529%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------HAyd0tcgDdUcgTVqRtY0dHw0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

>> I am not sure if this belongs in pgsql-general or pgsql-hackers, I am
>> trying first in psgl-general.
> Doesn't matter a lot, but as Rob noted, you should not hijack an
> existing thread.  Start your own thread, don't reply to an unrelated
> message.
My apologies.
> I don't see any discrepancy in your results, only in your choices of
> printf specifiers.  "%f" defaults to "%.6f", that is, print only six
> digits after the decimal point.  So a value down around 1e-12 is
> going to print as all zeroes.
>
>
Agreed. I should have noticed that my self.

Greg

--------------HAyd0tcgDdUcgTVqRtY0dHw0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <blockquote type="cite" cite="mid:602084.1773801455@sss.pgh.pa.us">
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">I am not sure if this belongs in pgsql-general or pgsql-hackers, I am 
trying first in psgl-general.
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
Doesn't matter a lot, but as Rob noted, you should not hijack an
existing thread.  Start your own thread, don't reply to an unrelated
message.</pre>
    </blockquote>
    My apologies. <br>
    <blockquote type="cite" cite="mid:602084.1773801455@sss.pgh.pa.us">
      <pre wrap="" class="moz-quote-pre">
I don't see any discrepancy in your results, only in your choices of
printf specifiers.  "%f" defaults to "%.6f", that is, print only six
digits after the decimal point.  So a value down around 1e-12 is
going to print as all zeroes.


</pre>
    </blockquote>
    Agreed. I should have noticed that my self.<br>
    <br>
    Greg<br>
    <br>
  </body>
</html>

--------------HAyd0tcgDdUcgTVqRtY0dHw0--