Re: ERROR: out of memory

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: ERROR: out of memory
Дата
Msg-id CAKFQuwZmagFXLpvfzJBdhzngR_Nst6D0JLLtjCGp8fv2fatWHw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: out of memory  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: ERROR: out of memory  (Dzmitry Nikitsin <dzmitry.nikitsin@gmail.com>)
Список pgsql-general
On Thursday, April 2, 2015, Melvin Davidson <melvin6925@gmail.com> wrote:
Well right of the bat, if your master shared_buffers = 7GB and 3 slaves shared_buffers = 10GB, that is 37GB total, which means you are guaranteed to exceed the 30GB physical limit on your machine. 

I don't get why you are adding these together.  There isn't any reason to assume the slaves are virtual machines sharing the same 30gb as opposed to each having 30gb for 120gb total between all 4.

David J.


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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: ERROR: out of memory
Следующее
От: Dzmitry Nikitsin
Дата:
Сообщение: Re: ERROR: out of memory