From: | Ryan Lambert <ryan(at)rustprooflabs(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: EXPLAIN ANALYZE not displaying recheck condition |
Date: | 2019-11-09 14:49:27 |
Message-ID: | CAN-V+g81WDxGWLVTB4CC-Ua4AGg6yVT5K1rJCkJ7uGXNzZscdg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thank you Jeff!
So this is an expected change when using both Pg12 and PostGIS 3 while
using an older version of either will still include the recheck. I
confirmed that PostGIS 3 with Pg11 still shows the recheck as expected.
Thanks,
*Ryan *
On Fri, Nov 8, 2019 at 11:54 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Fri, Nov 8, 2019 at 10:47 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
>> On Thu, Nov 7, 2019 at 5:04 PM Ryan Lambert <ryan(at)rustprooflabs(dot)com>
>> wrote:
>>
>>> Hello,
>>>
>>> In Pg12 I noticed the output from EXPLAIN ANALYZE no longer displays the
>>> recheck condition when using GIST indexes, such as:
>>>
>>>
>> I can't reproduce this using postgis 2.5.2 in Pg12. What version of
>> postgis are you using, and how did you install it?
>>
>
> This looks like an intended outcome of this commit (in postgis, not in
> PostgreSQL):
>
> commit 2f3e2783e7e1fa57a5a994e0c82d9784e94895b9
> Author: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
> Date: Wed Mar 6 17:27:24 2019 +0000
>
> Use "support function" API in PgSQL 12+ to provide index support for
> ST_Intersects and company, in place of old SQL inlining method.
> Closes #4341
>
> My interpretation is that the filter is at least as stringent as the
> recheck, so there is nothing to recheck.
>
> Cheers,
>
> Jeff
>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2019-11-09 18:27:35 | Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash |
Previous Message | James Coleman | 2019-11-09 13:23:23 | Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash |