Re: [GENERAL] migration to 9.6 array_accum memory issues

2017-03-27 Thread Tom Lane
Jiri Sadek writes: > On 27.3.2017 15:46, Tom Lane wrote: >> 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 > Actually we did all the testing on 9.6.2-1.pgdg16.04+1 from > http://apt.postgresql.org/pub

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), there >> was never such problem

Re: [GENERAL] migration to 9.6 array_accum memory issues

2017-03-27 Thread Tom Lane
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), there > was never such problem with 9.1. After some testing we found out t

[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