pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Lentfer <Jan.Lentfer@web.de>
To: AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: cache Memory of server
Date: Tue, 9 Jun 2015 10:15:57 +0200
Message-ID: <C5281527-721E-439B-A586-4300B1C89447@web.de> (raw)
In-Reply-To: <24F2E095E199B041912675E4E3BBA011B097AA27@WEXCPPA018.fhhnet.stadt.hamburg.de>
References: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de>
	<1de8696a86fac881688f0d463506f41a@imap.lan.net>
	<24F2E095E199B041912675E4E3BBA011B097AA27@WEXCPPA018.fhhnet.stadt.hamburg.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Shared buffers seem too low to me, usually you go for 20 - 25% of RAM for a dedicated DB server. work_mem also seems low, but that depends on your actual queries. You should at least log the usage of temp files and maybe look into pgbadger to analyze your logs.
Max_connections is way too high - espcially when you use a pooler. I get along using ca. 100 connections serving several hundreds of users using jdbc pooling.
You might want to take a look at pgtune.

Von meinem iPad gesendet

> Am 09.06.2015 um 10:07 schrieb AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>:
> 
> Hello Jan,
> 
> The shared_buffers ist 1024MB of the postgresql database and the kernel.shmmax=2147483648 (2GB) of linux OS.
> 
> And here is the some postgresql configurations:
> 
> work_mem=4MB
> max_connections=2800
> shared_buffers=1024MB
> 
> and the configuration of pgpool 
> init_childern=350
> max_pool=4
> 
> Regards
> Muthana
> 
> -----Ursprüngliche Nachricht-----
> Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von Jan Lentfer
> Gesendet: Montag, 8. Juni 2015 16:23
> An: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] cache Memory of server
> 
> 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (5+ messages)  latest in thread

Message-ID: <C5281527-721E-439B-A586-4300B1C89447@web.de>
Permalink:  ../C5281527-721E-439B-A586-4300B1C89447@web.de/
Also on:    postgresql.org/message-id/C5281527-721E-439B-A586-4300B1C89447@web.de

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Jan.Lentfer@web.de, muthana.al-temimi@tu-harburg.hamburg.de
  Subject: Re: cache Memory of server
  In-Reply-To: <C5281527-721E-439B-A586-4300B1C89447@web.de>
  References: <24F2E095E199B041912675E4E3BBA011B097A39C@WEXCPPA018.fhhnet.stadt.hamburg.de> <1de8696a86fac881688f0d463506f41a@imap.lan.net> <24F2E095E199B041912675E4E3BBA011B097AA27@WEXCPPA018.fhhnet.stadt.hamburg.de> <C5281527-721E-439B-A586-4300B1C89447@web.de>

* 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