Re: shared_buffers formula

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Alexander Shutyaev <shutyaev(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: shared_buffers formula
Date: 2015-03-04 10:11:48
Message-ID: 20150304101147.GG30405@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 2015-03-04 14:05:09 +0400, Alexander Shutyaev wrote:
> Thanks for the answer. Now, given this info I've calculated that our
> postgresql should occupy approx. 30,53 GB while the server has 125 GB of
> RAM. However we often see in top that there is very little free memory and
> even swap is used. What could be the reason of postgres using so much
> memory?

Presumably it's used by the OS to cache IO? Are you investigating an
actual problem with memory consumption or just wondering?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2015-03-04 11:11:49 Spam on main page
Previous Message Alexander Shutyaev 2015-03-04 10:05:09 Re: shared_buffers formula