Re: To increase RAM or not

From: Emanuel Calvo <emanuel(dot)calvo(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: To increase RAM or not
Date: 2014-10-22 14:39:08
Message-ID: 5447C18C.9060301@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

El 22/10/14 a las 02:37, Nikhil Daddikar escibió:
> Folks,
>
> I have set about 12GB RAM (shared buffers) for our Postgresql
> instance. How do I know if this is actually being used? And is
> there a way to know by how much should I increase it, if it is not
> enough?
>
> Thanks.
>

That's a lot if you are using the latest version.

There are several links and blogs related on this, here you have some
I found quickly:
http://rhaas.blogspot.com.es/2012/03/tuning-sharedbuffers-and-walbuffers.html

http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/

Try to filter those which are quite old if you don't want to mess up
with configuration variables like max_fsm_pages, etc.

- --
- --
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Bs. As., Argentina (GMT-3)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.18 (Darwin)
Comment: GPGTools - http://gpgtools.org

iQIcBAEBCgAGBQJUR8GLAAoJEIBeI/HMagHmFrUP/RxLhLEcmn/26Or5OrIYivYv
th37w05IAfRgQJgJk4OIsDKdbbEc/81H4GBu2B0JfW07YQHvxsNB8J0oW7PbAkEt
e+IrMYM13hSZecWXEuBrFHanM8WPoqcAKbJkXdzzZo75r9E/h8UTX87GOoXRqNbU
Y+vPA4pj0iywURMsJyR0cUqK5hygZUmGBfIEEQMAdl3KRxp/lJi5/hrP1H7FlYpm
n1e+AegNcMJPTHyCn9ghQ2I6bviNHDSTwqU9sUc545XuVG2ldDwXsFG+PvWxrx/S
+pm0OY0zBAv09hsXJRaHWS6e68tNGxb1GbkIzb/tLtLwC2ARZb79yuJEX4NKNXiH
Z6vWQF4fnxtjQzBE2SSnYLRtg0x1dDgqMVYC7Ez5kDqEJ7VnvMxAQms3Oo1hg4Lc
eTTumnK6k4SxRrKcBNQcdRx078OBuulfj89BT/vKaftIZfXMSi6mWY2aAyugXlAg
7kmY+Fqjcvm81NHoyAQTtA3ZDsL6PykshJiT/ySnI/JuHBGWZfU9CJjzkaFkWyRB
puDe6TZYH79RaE8aAc6VTWyp6cURisWbTT+MI2DKbYR+u8MPPzkzpt0BiiR79ciY
E5ci8kzi4wNJg6dtXO5otLGK6gpic8W7L2aLWqnBJqnQPYP0/w7S6IYeVK3VQ664
H93mtXqR0MoRlzbTDcsO
=jhtA
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2014-10-22 14:54:11 Re: To increase RAM or not
Previous Message Adrian Klaver 2014-10-22 13:46:07 Re: Inconsistency between PgAdmin III GUI and SQL window ?