To increase RAM or not

[Nikhil Daddikar]

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.

[Emanuel Calvo]

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

Post by Nikhil Daddikar
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-----

[Igor Neyman]

-----Original Message-----
From: pgsql-general-***@postgresql.org [mailto:pgsql-general-***@postgresql.org] On Behalf Of Emanuel Calvo
Sent: Wednesday, October 22, 2014 10:39 AM
To: pgsql-***@postgresql.org
Subject: Re: [GENERAL] To increase RAM or not

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

Post by Nikhil Daddikar
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


Here is couple great recent posts by Keith Fiske that help answering your question:

http://www.keithf4.com/a-small-database-does-not-mean-small-shared_buffers/

http://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/#comment-945


Regards,
Igor Neyman