it¹s 4 different servers. From: "David G. Johnston" <david.g.johns...@gmail.com> Date: Thursday, April 2, 2015 at 9:37 PM To: Melvin Davidson <melvin6...@gmail.com> Cc: Bob Jones <dzmitry.nikit...@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Subject: Re: [GENERAL] ERROR: out of memory
On Thursday, April 2, 2015, Melvin Davidson <melvin6...@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.