[postgis-tickets] [PostGIS] #3846: KNN test hangs in PgSQL 11

[PostGIS]

#3846: KNN test hangs in PgSQL 11
----------------------+---------------------------
  Reporter:  pramsey  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 pramsey how long does it hang for you.  Debbie's latest run on pg 11 which
 is based on postgres master from about 40 minutes ago looks okay or are
 you talking about testing with real data.


 {{{
 http://debbie.postgis.net:8080/job/PostGIS_Regress_PGDEV_Weekly/4545/consoleFull

 PostgreSQL 11devel on x86_64-pc-linux-gnu, compiled by gcc (Debian
 5.2.1-22) 5.2.1 20151010, 64-bit
   Postgis 2.4.0dev - r15710 - 2017-09-13 15:03:45
   scripts 2.4.0dev r15710
   GEOS: 3.7.0dev-CAPI-1.11.0 780221a5
   PROJ: Rel. 4.9.2, 08 September 2015
   SFCGAL: 1.3.0

 Running tests

  loader/Point .............. ok
  loader/PointM .............. ok
  loader/PointZ .............. ok
  loader/MultiPoint .............. ok
  loader/MultiPointM .............. ok
  loader/MultiPointZ .............. ok
  loader/Arc .............. ok
  loader/ArcM .............. ok
  loader/ArcZ .............. ok
  loader/Polygon .............. ok
  loader/PolygonM .............. ok
  loader/PolygonZ .............. ok
  loader/TSTPolygon ......... ok
  loader/TSIPolygon ......... ok
  loader/TSTIPolygon ......... ok
  loader/PointWithSchema ..... ok
  loader/NoTransPoint ......... ok
  loader/NotReallyMultiPoint ......... ok
  loader/MultiToSinglePoint ......... ok
  loader/ReprojectPts ........ ok
  loader/ReprojectPtsGeog ........ ok
  loader/Latin1 .... ok
  loader/Latin1-implicit .... ok
  loader/mfile .... ok
  dumper/literalsrid ....... ok
  dumper/realtable ....... ok
  affine .. ok
  bestsrid .. ok
  binary .. ok
  boundary .. ok
  cluster .. ok
  concave_hull .. ok
  ctors .. ok
  curvetoline .. ok
  dump .. ok
  dumppoints .. ok
  empty .. ok
  estimatedextent .. ok
  forcecurve .. ok
  geography .. ok
  geometric_median .. ok
  in_geohash .. ok
  in_gml .. ok
  in_kml .. ok
  in_encodedpolyline .. ok
  iscollection .. ok
  legacy .. ok
  long_xact .. ok
  lwgeom_regress .. ok
  measures .. ok
  minimum_bounding_circle .. ok
  normalize .. ok
  operators .. ok
  orientation .. ok
  out_geometry .. ok
  out_geography .. ok
  polygonize .. ok
  polyhedralsurface .. ok
  postgis_type_name .. ok
  regress .. ok
  regress_bdpoly .. ok
  regress_index .. ok
  regress_index_nulls .. ok
  regress_management .. ok
  regress_selectivity .. ok
  regress_lrs .. ok
  regress_ogc .. ok
  regress_ogc_cover .. ok
  regress_ogc_prep .. ok
  regress_proj .. ok
  relate .. ok
  remove_repeated_points .. ok
  removepoint .. ok
  reverse .. ok
  setpoint .. ok
  simplify .. ok
  simplifyvw .. ok
  size .. ok
  snaptogrid .. ok
  split .. ok
  sql-mm-serialize .. ok
  sql-mm-circularstring .. ok
  sql-mm-compoundcurve .. ok
  sql-mm-curvepoly .. ok
  sql-mm-general .. ok
  sql-mm-multicurve .. ok
  sql-mm-multisurface .. ok
  swapordinates .. ok
  summary .. ok
  temporal .. ok
  tickets .. ok
  twkb .. ok
  typmod .. ok
  wkb .. ok
  wkt .. ok
  wmsservers .. ok
  knn_recheck .. ok
  temporal_knn .. ok
  hausdorff .. ok
  regress_buffer_params .. ok
  frechet .. ok
  offsetcurve .. ok
  relatematch .. ok
  isvaliddetail .. ok
  sharedpaths .. ok
  snap .. ok
  node .. ok
  unaryunion .. ok
  clean .. ok
  relate_bnr .. ok
  delaunaytriangles .. ok
  interrupt .. ok
  interrupt_relate .. ok
  interrupt_buffer .. ok
  clipbybox2d .. ok
  subdivide .. ok
  voronoi .. ok
  minimum_clearance .. ok
  in_geojson .. ok
  regress_brin_index .. ok
  regress_brin_index_3d .. ok
  regress_brin_index_geography .. ok
  mvt .. ok
  geobuf .. ok
  mvt_jsonb .. ok
  regress_sfcgal .. ok
  sfcgal/empty .. ok
  sfcgal/geography .. ok
  sfcgal/legacy .. ok
  sfcgal/measures .. ok
  sfcgal/regress_ogc_prep .. ok
  sfcgal/regress_ogc .. ok
  sfcgal/regress .. ok
  sfcgal/tickets .. ok
  sfcgal/concave_hull .. ok
  sfcgal/wmsservers .. ok
  sfcgal/approximatemedialaxis .. ok
  uninstall .
 /var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.4/regress/00
 -regress-install/share/contrib/postgis/uninstall_sfcgal.sql
   /var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.4/regress/00
 -regress-install/share/contrib/postgis/uninstall_postgis.sql
 . ok (4690)

 Run tests: 138
 Failed: 0
 }}}


 granted we don't have a timing test in there.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3846#comment:1>
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.