Re: ERROR: out of memory

[Dzmitry Nikitsin <dzmitry.nikitsin@xxxxxxxxx>]

it’s 4 different servers. 

From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Thursday, April 2, 2015 at 9:37 PM
To: Melvin Davidson <melvin6925@xxxxxxxxx>
Cc: Bob Jones <dzmitry.nikitsin@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: [GENERAL] ERROR: out of memory

On Thursday, April 2, 2015, Melvin Davidson <melvin6925@xxxxxxxxx> 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.