Re: Service outage: each postgres process use the exact amount of the configured work_mem

From: Chris Mair <chris(at)1006(dot)org>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>, Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Service outage: each postgres process use the exact amount of the configured work_mem
Date: 2017-04-14 18:42:02
Message-ID: 61eb287fe9ac6841b231e9903e6f204a@smtp.hushmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> you should increase shared_memory to 40GB. General philosphy is to allocate 80% of system memory to shared_memory

Uhm...

80% is too much, likely:

https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html

Bye,
Chris.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-04-14 18:55:33 Re: Service outage: each postgres process use the exact amount of the configured work_mem
Previous Message Igor Neyman 2017-04-14 18:40:39 Re: Service outage: each postgres process use the exact amount of the configured work_mem