Re: migration to 9.6 array_accum memory issues

On 27.3.2017 15:46, Tom Lane wrote:
> 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
>

Actually we did all the testing on 9.6.2-1.pgdg16.04+1 from
http://apt.postgresql.org/pub/repos/apt/ repository.

Regards
Jiri