[postgis-tickets] [PostGIS] #2385: ST_MakeLine causing out of memory error

[PostGIS]

#2385: ST_MakeLine causing out of memory error
----------------------+-----------------------------------------------------
  Reporter:  ris      |       Owner:  pramsey                     
      Type:  defect   |      Status:  reopened                    
  Priority:  medium   |   Milestone:  PostGIS Future              
 Component:  postgis  |     Version:  2.0.x                       
Resolution:           |    Keywords:  ST_MakeLine memory aggregate
----------------------+-----------------------------------------------------

Comment(by pramsey):

 Well, forming a 10M point line from 10M points can be reasonably expected
 to take about 500Mb (about 250M for each set of 10M points, and you will
 have both the line and points in memory at the time you finish). And since
 you're crossing a relation of 10m with a relation of 10 in your increased
 example, you're looking at 5Gb, which seems legitimately out of memory, no
 leaks or bad practice required.

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