From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Ryan Lambert <ryan(at)rustprooflabs(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: EXPLAIN ANALYZE not displaying recheck condition |
Date: | 2019-11-08 15:47:53 |
Message-ID: | CAMkU=1ytQ8c8+5S-UxQBrOdjY731Ew7EaNLpDTVwXCo6DO+k3A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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?
I use this sequence of commands, and I still get the recheck listed:
create schema osm;
create extension postgis;
create table osm.boundary_polygon (way geometry, name text);
create table osm.road_line (way geometry, highway text, ref text);
create index on osm.road_line using gist (way );
set enable_indexscan TO off;
set enable_seqscan TO off;
EXPLAIN (ANALYZE)
SELECT r.highway, r.ref, r.way
FROM osm.boundary_polygon b
INNER JOIN osm.road_line r ON ST_Contains(b.way, r.way)
WHERE b.name = 'Jefferson County' ;
Cheers,
Jeff
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2019-11-08 16:11:50 | Re: BUG #16098: unexplained autovacuum to prevent wraparound |
Previous Message | Tom Lane | 2019-11-08 15:06:38 | Re: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10 |