Jiri Sadek <jiri.sa...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
