[postgis-tickets] [PostGIS] #2269: Unreasonable memory usage when analyzing table with geometry column with many toasted datums

[PostGIS]

#2269: Unreasonable memory usage when analyzing table with geometry column with
many toasted datums
-------------------------+--------------------------------------------------
  Reporter:  pgeoghegan  |       Owner:  strk         
      Type:  defect      |      Status:  reopened     
  Priority:  high        |   Milestone:  PostGIS 2.0.4
 Component:  postgis     |     Version:  2.0.x        
Resolution:              |    Keywords:  toast,leak   
-------------------------+--------------------------------------------------

Comment(by robe):

 You change to 2.0 branch appears to be causing debbie to crash on 8.4
 test.


 {{{
 PostgreSQL 8.4.17 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian
 4.4.5-8) 4.4.5, 64-bit
  Postgis 2.0.4SVN - r11273 - 2013-04-09 20:27:06
    GEOS: 3.3.9dev-CAPI-1.7.9
    PROJ: Rel. 4.7.1, 23 September 2009

 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
  binary .. ok
  regress .. ok
  regress_index .. ok
  regress_index_nulls .. ok
  lwgeom_regress .. ok
  regress_lrs .. ok
  removepoint .. ok
  setpoint .. ok
  simplify .. ok
  snaptogrid .. ok
  summary .. ok
  affine .. ok
  empty .. ok
  measures .. ok
  legacy .. ok
  long_xact .. ok
  ctors .. 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
  polyhedralsurface .. ok
  polygonize .. ok
  postgis_type_name .. ok
  out_geometry .. ok
  out_geography .. ok
  in_gml .. ok
  in_kml .. ok
  iscollection .. ok
  regress_ogc .. ok
  regress_ogc_cover .. ok
  regress_ogc_prep .. ok
  regress_bdpoly .. ok
  regress_proj .. ok
  regress_management .. ok
  dump .. ok
  dumppoints .. ok
  wmsservers .. ok
  wkt .. ok
  wkb .. ok
  tickets .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_66_diff)
  typmod .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_67_diff)
  remove_repeated_points .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_68_diff)
  split .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_69_diff)
  relate .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_70_diff)
  bestsrid .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_71_diff)
  concave_hull .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_72_diff)
  hausdorff .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_73_diff)
  regress_buffer_params .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_74_diff)
  offsetcurve .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_75_diff)
  relatematch .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_76_diff)
  isvaliddetail .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_77_diff)
  sharedpaths .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_78_diff)
  snap .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_79_diff)
  node .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_80_diff)
  unaryunion .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_81_diff)
  clean .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_82_diff)
  relate_bnr .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_83_diff)
  in_geojson .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_84_diff)
  uninstall . failed (uninstall_postgis.sql failed:
 /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/uninstall.err)
 .psql: FATAL:  the database system is in recovery mode
 dropdb: could not connect to database postgres: FATAL:  the database
 system is in recovery mode
 test: 1052: Something: unexpected operator
  ok (3699)

 Run tests: 85
 Failed: 20
 make[1]: *** [check] Error 20
 make[1]: Leaving directory
 `/var/lib/jenkins/workspace/postgis/branches/2.0/regress'
 make: *** [check] Error 1
 Build step 'Execute shell' marked build as failure
 An attempt to send an e-mail to empty list of recipients, ignored.
 Finished: FAILURE
 }}}

 I retested to make sure it wasn't a fluke and crsashed the second time in
 same spot

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2269#comment:4>
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.