shared_buffers formula

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2015-03-03 11:26:22 Re: shared_buffers formula
Previous Message Novák 2015-03-03 10:35:11 Re: Fwd: Data corruption after restarting replica