[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 15:45:08 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:  blocker     |   Milestone:  PostGIS 2.0.4
 Component:  postgis     |     Version:  2.0.x        
Resolution:              |    Keywords:  toast,leak   
-------------------------+--------------------------------------------------

Comment(by strk):

 r11275 in 2.0 and r11276 in trunk

 It's still to be researched what effects will the stawidth change have on
 the planner.
 Maybe it'll consider sequential scans cheaper. Did you ever work on that
 testing support for planner pramsey ?

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