AW: Out of memory in big transactions after upgrade to 12.2

2020-04-06 Thread Jan Strube
not sure this was clear from the stack trace. Von: Michael Lewis [mailto:mle...@entrata.com] Gesendet: Freitag, 3. April 2020 18:30 An: David Day Cc: Pavel Stehule ; Jan Strube ; pgsql-general@lists.postgresql.org Betreff: Re: Out of memory in big transactions after upgrade to 12.2 If you didn&#

Re: Out of memory in big transactions after upgrade to 12.2

2020-04-03 Thread Michael Lewis
If you didn't turn it off, you have parallel workers on by default with v12. If work_mem is set high, memory use may be much higher as each node in a complex plan could end up executing in parallel. Also, do you use a connection pooler such as pgbouncer or pgpool? What is max_connections set to?