Jiri Sadek <jiri.sadek@gmail.com> writes:
> we are in the process of migrating postgresql 9.1 to 9.6 and we
> encounter a memory issues with 9.6 - one of our procedure consumed all
> free memory (~8GB) of the testing server (and make it to swap), there
> was never such problem with 9.1. After some testing we found out that it
> is caused by user-defined aggregate array_accum (defined as in postgres
> documentation). We rewrote this procedure using built-in array_agg
> function and it seems to work better (at least it is usable).
9.6.what?
I think you'll find that 9.6.2 makes this significantly better.
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=48a6592da
regards, tom lane