[postgis-tickets] [PostGIS] #4139: Unstable behavior of gist nd indexes

[PostGIS]

#4139: Unstable behavior of gist nd indexes
-----------------------+---------------------------
  Reporter:  ezimanyi  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.4.5
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by Algunenano):

 I'm not able to reproduce it with trunk:
 {{{
 index_test=# select count(*) from tbl_geomcollection_nd t1,
 tbl_geomcollection_nd t2 where t1.g &&& t2.g;
   count
 ---------
  4451734
 (1 row)

 index_test=# select count(*) from tbl_geomcollection_nd t1,
 tbl_geomcollection_nd t2 where t1.g &&& t2.g;
   count
 ---------
  4451734
 (1 row)

 index_test=# EXPLAIN ANALYZE select count(*) from tbl_geomcollection_nd
 t1, tbl_geomcollection_nd t2 where t1.g &&& t2.g;
 QUERY PLAN

 -------------------------------------------------------------------------------------------------------------------------------------------
 -------------------------------------
  Aggregate  (cost=10000001376.15..10000001376.16 rows=1 width=8) (actual
 time=1889.556..1889.556 rows=1 loops=1)
    ->  Nested Loop  (cost=10000000000.15..10000001364.00 rows=4860
 width=0) (actual time=0.085..1705.876 rows=4451734 loops=1)
          ->  Seq Scan on tbl_geomcollection_nd t1
 (cost=10000000000.00..10000000186.00 rows=2400 width=596) (actual
 time=0.014..0.338 rows
 =2400 loops=1)
          ->  Index Scan using tbl_geomcollection_nd_gist_nd_idx on
 tbl_geomcollection_nd t2  (cost=0.14..0.48 rows=1 width=596) (actual tim
 e=0.019..0.603 rows=1855 loops=2400)
                Index Cond: (t1.g &&& g)
  Planning Time: 0.424 ms
  Execution Time: 1889.612 ms
 (7 rows)

 index_test=#
 }}}

 Can you report what Postgis and Postgresql versions are you using? Also an
 `EXPLAIN
 ANALYZE` of the query.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4139#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.