Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem - Mailing list pgsql-general

From Chris Mair
Subject Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Date
Msg-id 3c67d18adc2ac4d9351f9384508b4418@smtp.hushmail.com
Whole thread Raw
In response to Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Next
From: Vincent Elschot
Date:
Subject: Re: [GENERAL] dynamic schema modeling and performance