Re: EXPLAIN ANALYZE not displaying recheck condition
| От | Ryan Lambert |
|---|---|
| Тема | Re: EXPLAIN ANALYZE not displaying recheck condition |
| Дата | |
| Msg-id | CAN-V+g81WDxGWLVTB4CC-Ua4AGg6yVT5K1rJCkJ7uGXNzZscdg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: EXPLAIN ANALYZE not displaying recheck condition (Jeff Janes <jeff.janes@gmail.com>) |
| Список | 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.janes@gmail.com> wrote:
On Fri, Nov 8, 2019 at 10:47 AM Jeff Janes <jeff.janes@gmail.com> wrote:On Thu, Nov 7, 2019 at 5:04 PM Ryan Lambert <ryan@rustprooflabs.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@cleverelephant.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
В списке pgsql-bugs по дате отправления: