[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 ris):

 Hmm. That example doesn't fail for me though on my Debian/9.1.9/1.5.3
 machine, even if I raise the 1m to 10m.

 However, doing a

 {{{
 CREATE TABLE bar AS
 SELECT * FROM
    generate_series ( 1 , 1000000 ) AS a ,
    generate_series ( 1 , 10 ) AS b;

 SELECT ST_MakeLine ( ST_Point ( a , b ) ) FROM bar GROUP BY a;
 }}}

 does indeed raise the same out of memory error.

 As does exchanging ST_MakeLine for ST_Collect in both cases, though in the
 generate_series example the error is "...size 16" and, interestingly, in
 the materialized table example I have to up it to 10m for it to fail and
 it instead gives me the slightly different

 {{{
 out of memory for query result
 }}}

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