Re: ERROR: out of memory

From: Dzmitry Nikitsin <dzmitry(dot)nikitsin(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: out of memory
Date: 2015-04-03 01:45:26
Message-ID: D14368C2.22EC1%dzmitry.nikitsin@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

it¹s 4 different servers.

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

On Thursday, April 2, 2015, Melvin Davidson <melvin6925(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dzmitry Nikitsin 2015-04-03 01:55:40 Re: ERROR: out of memory
Previous Message David G. Johnston 2015-04-03 01:37:09 Re: ERROR: out of memory