pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Adarsh Sharma <adarsh.sharma@orkash.com>
To: Raghavendra <raghavendra.rao@enterprisedb.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: sethuprasad.in@gmail.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Performance Tuning
Date: Mon, 04 Apr 2011 17:04:24 +0530
Message-ID: <4D99ACC0.5090009@orkash.com> (raw )
In-Reply-To: <BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com >
References: <4D999211.9080507@orkash.com >
<BANLkTi=ykDDwaAxphKH061Y2aZ1ygnmPEA@mail.gmail.com >
<BANLkTinONdxh35_0rTdg1L7K=C1KimRUnA@mail.gmail.com >
<BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com >
My database size is :-
postgres=# select pg_size_pretty(pg_database_size('pdc_uima_dummy'));
pg_size_pretty
----------------
49 GB
(1 row)
I have a doubt regarding postgres Memory Usage :-
Say my Application makes Connection to Database Server ( *.*.*.106) from
(*.*.*.111, *.*.*.113, *.*.*.114) Servers and I check the top command as
:-- Say it makes 100 Connections
top - 17:01:02 up 5:39, 4 users, load average: 0.00, 0.00, 0.00
Tasks: 170 total, 1 running, 169 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.2% sy, 0.0% ni, 99.6% id, 0.1% wa, 0.0% hi,
0.0% si, 0.0% st
Mem: 16299476k total, 16198784k used, 100692k free, 73776k buffers
Swap: 16787884k total, 148176k used, 16639708k free, 15585396k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
COMMAND
3401 postgres 20 0 4288m 3.3g 3.3g S 0 21.1 0:24.73
postgres
3397 postgres 20 0 4286m 119m 119m S 0 0.8 0:00.36
postgres
4083 postgres 20 0 4303m 104m 101m S 0 0.7 0:07.68
postgres
3402 postgres 20 0 4288m 33m 32m S 0 0.2 0:03.67
postgres
4082 postgres 20 0 4301m 27m 25m S 0 0.2 0:00.85
postgres
4748 postgres 20 0 4290m 5160 3700 S 0 0.0 0:00.00
postgres
4173 root 20 0 12340 3028 1280 S 0 0.0 0:00.12
bash
4084 postgres 20 0 4290m 2952 1736 S 0 0.0 0:00.00
postgres
4612 root 20 0 12340 2920 1276 S 0 0.0 0:00.06
bash
4681 root 20 0 12340 2920 1276 S 0 0.0 0:00.05
bash
4550 root 20 0 12208 2884 1260 S 0 0.0 0:00.08
bash
4547 root 20 0 63580 2780 2204 S
and free command says :--
[root@s8-mysd-2 8.4SS]# free -g
total used free shared buffers cached
Mem: 15 15 0 0 0 14
-/+ buffers/cache: 0 15
Swap: 16 0 15
[root@s8-mysd-2 8.4SS]#
Now when my job finishes and I close the Connections from 2 Servers ,
the top & free output remains the same :-
I don't know What is the reason behind this as I have only 3 Connections
from the below command :
postgres=# select datname, client_addr,current_query from pg_stat_activity;
datname | client_addr |
current_query
----------------+---------------+------------------------------------------------------------------
postgres | | select datname,
client_addr,current_query from pg_stat_activity;
postgres | 192.168.0.208 | <IDLE>
pdc_uima_s9 | 192.168.0.208 | <IDLE>
pdc_uima_s9 | 192.168.0.208 | <IDLE>
pdc_uima_dummy | 192.168.0.208 | <IDLE>
pdc_uima_dummy | 192.168.1.102 | <IDLE>
pdc_uima_dummy | 192.168.1.102 | <IDLE>
pdc_uima_dummy | 192.168.1.102 | <IDLE>
(8 rows)
PLease help me to understand how much memory does 1 Connection Uses and
how to use Server parameters accordingly.
Thanks & best Regards,
Adarsh Sharma
Raghavendra wrote:
> Adarsh,
>
> What is the Size of Database?
>
> Best Regards,
> Raghavendra
> EnterpriseDB Corporation
>
> On Mon, Apr 4, 2011 at 4:24 PM, Scott Marlowe <scott.marlowe@gmail.com
> <mailto:scott.marlowe@gmail.com>> wrote:
>
> On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe
> <scott.marlowe@gmail.com <mailto:scott.marlowe@gmail.com>> wrote:
> >
> >> [root@s8-mysd-2 ~]# free total used
> free shared
> >> buffers cached
> >> Mem: 16299476 16202264 97212 0 58924
> 15231852
> >> -/+ buffers/cache: 911488 15387988
> >> Swap: 16787884 153136 16634748
> >
> > There is nothing wrong here. You're using 153M out of 16G swap.
> 15.x
> > Gig is shared buffers. If your system is slow, it's not because
> it's
> > running out of memory or using too much swap.
>
> Sorry that's 15.xG is system cache, not shared buffers. Anyway, still
> not a problem.
>
> --
> Sent via pgsql-performance mailing list
> (pgsql-performance@postgresql.org
> <mailto:pgsql-performance@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
view thread (22+ messages) latest in thread
Message-ID: <4D99ACC0.5090009@orkash.com>
Permalink: ../4D99ACC0.5090009@orkash.com/
Also on: postgresql.org/message-id/4D99ACC0.5090009@orkash.com
copy link · copy postgr.es
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adarsh.sharma@orkash.com, raghavendra.rao@enterprisedb.com, scott.marlowe@gmail.com, sethuprasad.in@gmail.com
Subject: Re: Postgres Performance Tuning
In-Reply-To: <4D99ACC0.5090009@orkash.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