Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z1xxI-0002Zk-Q8 for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jun 2015 14:23:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z1xxH-0008W9-2X for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jun 2015 14:23:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z1xxF-0008W2-NP for pgsql-admin@postgresql.org; Mon, 08 Jun 2015 14:23:09 +0000 Received: from mout.web.de ([212.227.17.11]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1Z1xxC-0001bf-M4 for pgsql-admin@postgresql.org; Mon, 08 Jun 2015 14:23:08 +0000 Received: from vm-mailsrv.lan.net ([87.155.106.234]) by smtp.web.de (mrweb101) with ESMTPSA (Nemesis) id 0MNtTz-1Z04HL0DrH-007R2J for ; Mon, 08 Jun 2015 16:23:04 +0200 Received: from localhost (localhost [127.0.0.1]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 2CC44187EE for ; Mon, 8 Jun 2015 16:23:03 +0200 (CEST) X-Spam-Flag: NO X-Spam-Score: -2.899 X-Spam-Level: X-Spam-Status: No, score=-2.899 tagged_above=-99.9 required=6.31 tests=[ALL_TRUSTED=-1, BAYES_00=-1.9, FREEMAIL_FROM=0.001] autolearn=ham autolearn_force=no Received: from vm-mailsrv.lan.net ([127.0.0.1]) by localhost (vm-mailsrv.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kDbew1dIeYmo for ; Mon, 8 Jun 2015 16:22:56 +0200 (CEST) Received: from neslonek.homeunix.org (vm-webapp-ext.dmz-lan.net [192.168.0.100]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 96453F12E for ; Mon, 8 Jun 2015 16:22:56 +0200 (CEST) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Date: Mon, 08 Jun 2015 16:22:56 +0200 From: Jan Lentfer To: Subject: Re: cache Memory of server In-Reply-To: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de> References: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de> Message-ID: <1de8696a86fac881688f0d463506f41a@imap.lan.net> X-Sender: Jan.Lentfer@web.de User-Agent: Roundcube Webmail/0.7.2 X-Provags-ID: V03:K0:QtKE1PohhxmPLgd+g/vrmQXzT/6eFtr6WJq8kgkxM5wIL2HGnKb qf5nq6MaLsnu0lzRPD7+izWtxnv0w60EE99AIPKqIF1yePKprhvaYDmcLbkj6KAHNOOUMJe Hjh6cCio7sCzTs/9CYDwGNTNN3jBuYn/IuxexgEW3HerlI61gNcSY20ofW/8VY3U+kcEklc XGReaKY+iqnsFs6ES6bCA== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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