Re: postgresql 9.5 has ocuuered OOM - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: postgresql 9.5 has ocuuered OOM
Date
Msg-id 89cc08c6-7707-d5e2-589e-8c0a31774ba9@a-kretschmer.de
Whole thread Raw
In response to Re: postgresql 9.5 has ocuuered OOM  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List 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



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: postgresql 9.5 has ocuuered OOM
Next
From: Mike Feld
Date:
Subject: psycopg2 and java gssapi questions