tag:blogger.com,1999:blog-6018614372585319965.post8647584433566561635..comments2024-02-25T09:25:41.902+01:00Comments on Valentine's tech log: PostgreSQL array aggregateAnonymoushttp://www.blogger.com/profile/02521879454303479150noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6018614372585319965.post-20104019863384813962011-02-24T15:18:26.044+01:002011-02-24T15:18:26.044+01:00@Pavel
This is a very old post actually :) So now...@Pavel<br /><br />This is a very old post actually :) So now one should definitely use a build-in... <br /><br />Another thing is, that this method, does not leek memory like some early implementations of the array_agg... and I found recently at least one "conservatively" maintained production system, where the memory leek of array_agg was still an issue (as far as I remember it was a 8.4.1 or even 8.4.0)Anonymoushttps://www.blogger.com/profile/02521879454303479150noreply@blogger.comtag:blogger.com,1999:blog-6018614372585319965.post-49326499269284613042011-02-24T11:32:22.981+01:002011-02-24T11:32:22.981+01:00atention - these custom aggregates are slow - use ...atention - these custom aggregates are slow - use buildin array_agg instead when is possiblePavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-6018614372585319965.post-88160273135101319452009-09-14T21:17:55.996+02:002009-09-14T21:17:55.996+02:00thanks for the explication, very useful :)thanks for the explication, very useful :).https://www.blogger.com/profile/12418781492399393868noreply@blogger.com