pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcache Memory
3+ messages / 2 participants
[nested] [flat]
* cache Memory
@ 2015-06-08 13:23 AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
2015-06-08 13:40 ` Re: cache Memory Scott Ribe <scott_ribe@elevated-dev.com>
2015-06-08 13:51 ` Re: cache Memory Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 3+ messages in thread
From: AL-Temimi, Muthana @ 2015-06-08 13:23 UTC (permalink / raw)
To: pgsql-admin
Hello,
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
any help will be grateful..
Best Regards
Muthana AL-Temimi
M.Sc. Informations- und Kommunikations-Systeme
Technische Universitaet Hamburg Harburg
-Rechenzentrum-
Am Schwarzenberg-Campus 3
D-21073 Hamburg
Tel.: +49.40.42878.2338
Fax.: +49.40.42793.5160
E-Mail: m.al@tu-harburg.de<mailto:m.al@tu-harburg.de>
http://www.tu-harburg.de/rzt
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: cache Memory
2015-06-08 13:23 cache Memory AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
@ 2015-06-08 13:40 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2015-06-08 13:40 UTC (permalink / raw)
To: AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: cache Memory
2015-06-08 13:23 cache Memory AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
@ 2015-06-08 13:51 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2015-06-08 13:51 UTC (permalink / raw)
To: AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>; +Cc: pgsql-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
>
> any help will be grateful..
Probably also good to confirm what you mean by "cache memory"--what exactly are you measuring? For instance, if you're measuring the OS cache for the file system, then no, it wouldn't be expected to ever decrease until something else needed the memory...
--
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-06-08 13:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-06-08 13:23 cache Memory AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
2015-06-08 13:40 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-06-08 13:51 ` Scott Ribe <scott_ribe@elevated-dev.com>
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