Re: Out of memory in big transactions after upgrade to 12.2 - Mailing list pgsql-general

From Michael Lewis
Subject Re: Out of memory in big transactions after upgrade to 12.2
Date
Msg-id CAHOFxGqXtUsbjgc=p7XcOgi4sbPb5WFnMgAakQKEgJmExHznVw@mail.gmail.com
Whole thread Raw
In response to Re: Out of memory in big transactions after upgrade to 12.2  (David Day <djd2403@gmail.com>)
Responses AW: Out of memory in big transactions after upgrade to 12.2
List pgsql-general
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?

pgsql-general by date:

Previous
From: Moses Mafusire
Date:
Subject: Re: Cstore_fdw issue.
Next
From: Adrian Klaver
Date:
Subject: Re: Cstore_fdw issue.