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

From: Chris Mair <chris(at)1006(dot)org>
To: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>, 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:08:10
Message-ID: 3c67d18adc2ac4d9351f9384508b4418@smtp.hushmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Sorry,
> my mistake (I'm a bit nervous...)
>
> that's not work_mem, but shared_buffers

Hi.

The resident set size of the worker processes includes all shared memory blocks they touched.
So it's not that each of those workers allocated their own 3GB...

(in Linux at least)

Bye,
Chris.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Elschot 2017-04-14 18:23:09 Re: dynamic schema modeling and performance
Previous Message Jeff Janes 2017-04-14 18:05:13 Re: Service outage: each postgres process use the exact amount of the configured work_mem