| 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: | Whole Thread | Raw Message | 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.
| 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 |