From: Scott Ribe <scott_ribe@elevated-dev.com>
To: AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: cache Memory
Date: Mon, 8 Jun 2015 07:40:34 -0600
Message-ID: <B4B0A668-2410-4FEF-A6F4-96A0CFDCA341@elevated-dev.com> (raw)
In-Reply-To: <24F2E095E199B041912675E4E3BBA011B097A342@WEXCPPA018.fhhnet.stadt.hamburg.de>
References: <24F2E095E199B041912675E4E3BBA011B097A342@WEXCPPA018.fhhnet.stadt.hamburg.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Jun 8, 2015, at 7:23 AM, AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de> wrote:
>
> we have postgresql 9.1 installed on Suse Enterprice Linux Server. The RAM is 12GB, When the concurrent connections 275 reached the cached memory on Server 5GB and when the concurrent increased into 305 increase also the cache memory 8.5GB. but when the concurrent connections decreased into for example 165 the cache memory not decreased. The question why? Did I mess something the postgresql.conf
- What are your memory-related config settings?
- Consider using pgbouncer to reduce the number of connections.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, muthana.al-temimi@tu-harburg.hamburg.de
Subject: Re: cache Memory
In-Reply-To: <B4B0A668-2410-4FEF-A6F4-96A0CFDCA341@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox