Re: array_agg() on a set larger than some arbitrary(?) limit causes runaway memory usage and eventually memory exhaustion - Mailing list pgsql-bugs

Hi Valentine,

Op zondag 20 oktober 2013 14:06:19 schreef Valentine Gogichashvili:
Apropos, how does the string_agg aggregate behave in your example?
Will be nice to know without experimenting myself and looking into the
sources :)



Interesting....

On the 1e7 dataset, our custom comcat() function runs for ~18.5
seconds and eats up to ~6,5 GB of memory, while the string_agg() on
the same dataset runs for ~23.5 seconds and eats up to ~16 GB of
memory.




--

Best,




Frank.