| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | Julien Rouhaud <rjuju123(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
| Subject: | Re: Inconsistent results from seqscan and gist indexscan |
| Date: | 2021-11-27 02:51:51 |
| Message-ID: | 477813.1637981511@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> On Fri, Nov 26, 2021 at 5:23 PM Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
>> On Fri, Nov 26, 2021 at 2:10 PM Richard Guo <guofenglinux(at)gmail(dot)com>
>> wrote:
>>> Seems point_inside() does not handle NaN properly.
>> This is unfortunately a known issue, which was reported twice ([1] and
>> [2]) already. There's a patch proposed for it:
>> https://commitfest.postgresql.org/32/2710/ (adding Horiguchi-san in
>> Cc).
> Ah, I missed the previous threads. Good to know there is a patch fixing
> it.
Note that that patch seems pretty well stalled; if you'd like to
see it move forward, please pitch in and help review.
(Maybe we should scale back the patch's ambitions, and just try
to get the seqscan/indexscan inconsistency fixed.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2021-11-27 10:56:40 | Re: Skipping logical replication transactions on subscriber side |
| Previous Message | Tom Lane | 2021-11-27 02:46:55 | Re: WIP: WAL prefetch (another approach) |