Обсуждение: To increase RAM or not
Folks, I have set about 12GB RAM (shared buffers) for our Postgresql instance. How do I know if this is actually being used? Andis there a way to know by how much should I increase it, if it is not enough? Thanks.
-----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-----
-----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