From: | Alexander Shutyaev <shutyaev(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | shared_buffers formula |
Date: | 2015-03-03 11:06:54 |
Message-ID: | CAGBp8g_W-y2T_1osM2cyO=2XzL96hQe2Ccq3tiR69a6tkeGLbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all!
Recently we've been having problems with swap on our postgresql server. It
has 125GB of RAM. We've decided to calculate it's memory consumption. To do
this we've used the formulas from the official docs [1]. However there is
one parameter that seems strange - Shared disk buffers. According to the
formula it occupies the following space:
(block_size + 208) * shared_buffers
Our values are
block_size=8192
shared_buffers=30GB
The block_size has the default value and shared_buffers was calculated by
pgtune. According to the formula the product will be around 252 000 GB
which doesn't make any sense. Is there something wrong with the formula? Or
should we make our shared_buffers approx. 10 000 times lower? :)
Thanks in advance,
Alexander Shutyaev
[1]
http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SHARED-MEMORY-PARAMETERS
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2015-03-03 11:26:22 | Re: shared_buffers formula |
Previous Message | 2015-03-03 10:35:11 | Re: Fwd: Data corruption after restarting replica |