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

PostGIS trac at osgeo.org
Thu Jul 18 09:51:16 PDT 2013


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

 My computer is really big and it doesn't crash on your example, but it
 does show a pretty big resident size on the process when the query in run.
 The thing it, this query show basically the same resident size, and
 doesn't have any spatial stuff in it at all:
 {{{
 create table foo as
 select count(*) FROM
   generate_series ( 1 , 1000000 ) AS a,
   generate_series ( 1 , 10 ) AS b
 GROUP BY a;
 }}}

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