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
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?