Re: [GENERAL] migration to 9.6 array_accum memory issues

2017-03-27 Thread Jiri Sadek
On 27.3.2017 15:46, Tom Lane wrote: > Jiri Sadek 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), th

[GENERAL] migration to 9.6 array_accum memory issues

2017-03-27 Thread Jiri Sadek
Hi all, 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