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

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Chris Mair <chris(at)1006(dot)org>
Cc: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>, "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:55:33
Message-ID: CANu8FixEzCn3zYi_S6U8yV6OYE=1GYL19UhFdrY71vsdzz02OA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair <chris(at)1006(dot)org> wrote:

> 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.
>
>
>
Sorry, I had a brain fart, shared_buffers should be 25% system memory, or
12GB

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2017-04-14 19:00:24 Re: Service outage: each postgres process use the exact amount of the configured work_mem
Previous Message Chris Mair 2017-04-14 18:42:02 Re: Service outage: each postgres process use the exact amount of the configured work_mem