Re: ERROR: out of memory - Mailing list pgsql-general

From David G. Johnston
Subject Re: ERROR: out of memory
Date
Msg-id CAKFQuwZmagFXLpvfzJBdhzngR_Nst6D0JLLtjCGp8fv2fatWHw@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: out of memory  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: ERROR: out of memory
List 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 by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: ERROR: out of memory
Next
From: Dzmitry Nikitsin
Date:
Subject: Re: ERROR: out of memory