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