Re: postgresql 9.5 has ocuuered OOM

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql 9.5 has ocuuered OOM
Date: 2017-12-20 18:15:40
Message-ID: 89cc08c6-7707-d5e2-589e-8c0a31774ba9@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 20.12.2017 um 17:24 schrieb Tomas Vondra:
> That means if you have all 50 connections active, they may easily
> consume 100% of memory, because 50 * 2 is 100. It's even easier if the
> connections are executing complex queries, because each query may use
> multiple work_mem buffers. So 2% seems a bit too high.

Nice hint! You are right.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Feld 2017-12-20 19:42:55 psycopg2 and java gssapi questions
Previous Message Scott Marlowe 2017-12-20 17:11:29 Re: postgresql 9.5 has ocuuered OOM