On 27.3.2017 15:46, Tom Lane wrote: > Jiri Sadek <jiri.sadek@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
