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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: David Day <djd2403(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Jan Strube <Jan(dot)Strube(at)solvians(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Out of memory in big transactions after upgrade to 12.2
Date: 2020-04-03 16:30:28
Message-ID: CAHOFxGqXtUsbjgc=p7XcOgi4sbPb5WFnMgAakQKEgJmExHznVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-03 16:39:50 Re: Cstore_fdw issue.
Previous Message Moses Mafusire 2020-04-03 16:26:31 Re: Cstore_fdw issue.