From: Jan Lentfer <Jan.Lentfer@web.de>
To: pgsql-admin@postgresql.org
Subject: Re: cache Memory of server
Date: Mon, 08 Jun 2015 16:22:56 +0200
Message-ID: <1de8696a86fac881688f0d463506f41a@imap.lan.net> (raw)
In-Reply-To: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de>
References: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 2015-06-08 15:53, schrieb AL-Temimi, Muthana:
> See the free command:
>
> am 08.06.2015 um 15:13 Uhr: --active connection: 305
>
> srvpgsql1:/opt/pgsql_data # free
>
> total used free shared buffers cached
>
> Mem: 12199684 8758400 3441284 1269784 231324 7139400
>
> -/+ buffers/cache: 1387676 10812008
>
> Swap: 6289404 0 6289404
>
>
> ----------------------------------------------------------------------
>
>
> am 08.06.2015 um 15:53 Uhr: --active connection: 278
>
> srvpgsql1:/opt/pgsql_data # free
>
> total used free shared buffers cached
>
> Mem: 12199684 8686228 3513456 1269784 232164 7164288
>
> -/+ buffers/cache: 1289776 10909908
>
> Swap: 6289404 0 6289404
>
That is basically what Scott said: you are watching the Kernel FS
cache. It may only be a coincidence that it increased together with the
postgres sessions. A high number here is usually somehting good, because
a lot of your filesystems reads will be served from RAM. Looking at your
numbers, I would say you are "all good" (except as Scott said, mabye try
to reduce number of parallel sessions) - big fs cache and still free
RAM.
What are your settings for shared buffers btw?
Jan
--
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: Jan.Lentfer@web.de
Subject: Re: cache Memory of server
In-Reply-To: <1de8696a86fac881688f0d463506f41a@imap.lan.net>
* 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