Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem

Поиск
Список
Период
Сортировка
От Chris Mair
Тема Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Дата
Msg-id 3c67d18adc2ac4d9351f9384508b4418@smtp.hushmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Следующее
От: Vincent Elschot
Дата:
Сообщение: Re: [GENERAL] dynamic schema modeling and performance