Opened 7 years ago

Closed 7 years ago

#3846 closed defect (fixed)

KNN test hangs in PgSQL 11

Reported by: pramsey Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.5.0
Component: postgis Version: master
Keywords: Cc:

Description

I have seen this really badly so far just on one machine, need to confirm that it's a v11 problem entirely. Reading the trace it looks like the index operator isn't actually calling into the index; the plan is a sequence, so the hang is to time it takes to run a KNN without the index, which is a long time on a big geograpy data set.

Change History (2)

comment:1 by robe, 7 years ago

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.

comment:2 by pramsey, 7 years ago

Resolution: → fixed
Status: new → closed

This appears to have cleared up in recent pulls.

Note: See TracTickets for help on using tickets.