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

PostGIS trac at osgeo.org
Tue Apr 9 14:46:22 PDT 2013


#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 pramsey):

 I'd expect trunk to blow chunks too,

 http://trac.osgeo.org/postgis/browser/trunk/postgis/geometry_estimate.c?rev=11274#L938

 the edit means that VARSIZE is being called on... something? Just pfreeing
 the geom at the end of the loop might be the preferred approach. Or, find
 out what we're supposed to be saving into stawidth, since that's black
 magic.

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


More information about the postgis-tickets mailing list