Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id A9AAB1337A5D
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  4 Apr 2011 08:34:38 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 65610-06
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  4 Apr 2011 11:34:29 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp180.iad.emailsrvr.com (smtp180.iad.emailsrvr.com
	[207.97.245.180])
	by mail.postgresql.org (Postfix) with ESMTP id C09D9133616B
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Apr 2011 08:34:27 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp48.relay.iad1a.emailsrvr.com (SMTP Server) with ESMTP id
	E371216816E; Mon,  4 Apr 2011 07:34:27 -0400 (EDT)
X-Virus-Scanned: OK
Received: by smtp48.relay.iad1a.emailsrvr.com (Authenticated sender:
	adarsh.sharma-AT-orkash.com) with ESMTPSA id DD6C3168176;
	Mon,  4 Apr 2011 07:34:25 -0400 (EDT)
Message-ID: <4D99ACC0.5090009@orkash.com>
Date: Mon, 04 Apr 2011 17:04:24 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: Raghavendra <raghavendra.rao@enterprisedb.com>
CC: Scott Marlowe <scott.marlowe@gmail.com>, sethuprasad.in@gmail.com,
	pgsql-performance@postgresql.org
Subject: Re: Postgres Performance Tuning
References: <4D999211.9080507@orkash.com>
	<BANLkTi=ykDDwaAxphKH061Y2aZ1ygnmPEA@mail.gmail.com>
	<BANLkTinONdxh35_0rTdg1L7K=C1KimRUnA@mail.gmail.com>
	<BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com>
In-Reply-To: <BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------050101010002010909000501"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201104/14
X-Sequence-Number: 43076

This is a multi-part message in MIME format.
--------------050101010002010909000501
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>


--------------050101010002010909000501
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
My database size is :- <br>
postgres=# select pg_size_pretty(pg_database_size('pdc_uima_dummy'));<br>
&nbsp;pg_size_pretty <br>
----------------<br>
&nbsp;49 GB<br>
(1 row)<br>
<br>
I have a doubt regarding postgres Memory Usage :-<br>
<br>
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<br>
<br>
top - 17:01:02 up&nbsp; 5:39,&nbsp; 4 users,&nbsp; load average: 0.00, 0.00, 0.00<br>
Tasks: 170 total,&nbsp;&nbsp; 1 running, 169 sleeping,&nbsp;&nbsp; 0 stopped,&nbsp;&nbsp; 0 zombie<br>
Cpu(s):&nbsp; 0.0% us,&nbsp; 0.2% sy,&nbsp; 0.0% ni, 99.6% id,&nbsp; 0.1% wa,&nbsp; 0.0% hi,&nbsp;
0.0% si,&nbsp; 0.0% st<br>
Mem:&nbsp; 16299476k total, 16198784k used,&nbsp;&nbsp; 100692k free,&nbsp;&nbsp;&nbsp; 73776k buffers<br>
Swap: 16787884k total,&nbsp;&nbsp; 148176k used, 16639708k free, 15585396k cached<br>
<br>
&nbsp; PID USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PR&nbsp; NI&nbsp; VIRT&nbsp; RES&nbsp; SHR S %CPU %MEM&nbsp;&nbsp;&nbsp; TIME+&nbsp;
COMMAND&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;3401 postgres&nbsp; 20&nbsp;&nbsp; 0 4288m 3.3g 3.3g S&nbsp;&nbsp;&nbsp; 0 21.1&nbsp;&nbsp; 0:24.73
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;3397 postgres&nbsp; 20&nbsp;&nbsp; 0 4286m 119m 119m S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.8&nbsp;&nbsp; 0:00.36
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4083 postgres&nbsp; 20&nbsp;&nbsp; 0 4303m 104m 101m S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.7&nbsp;&nbsp; 0:07.68
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;3402 postgres&nbsp; 20&nbsp;&nbsp; 0 4288m&nbsp; 33m&nbsp; 32m S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.2&nbsp;&nbsp; 0:03.67
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4082 postgres&nbsp; 20&nbsp;&nbsp; 0 4301m&nbsp; 27m&nbsp; 25m S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.2&nbsp;&nbsp; 0:00.85
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4748 postgres&nbsp; 20&nbsp;&nbsp; 0 4290m 5160 3700 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4173 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0 12340 3028 1280 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.12
bash&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4084 postgres&nbsp; 20&nbsp;&nbsp; 0 4290m 2952 1736 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4612 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0 12340 2920 1276 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.06
bash&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4681 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0 12340 2920 1276 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.05
bash&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4550 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0 12208 2884 1260 S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.08
bash&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
&nbsp;4547 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0 63580 2780 2204 S&nbsp;&nbsp; <br>
<br>
and free command says :--<br>
[root@s8-mysd-2 8.4SS]# free -g<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; used&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; free&nbsp;&nbsp;&nbsp;&nbsp; shared&nbsp;&nbsp;&nbsp; buffers&nbsp;&nbsp;&nbsp;&nbsp;
cached<br>
Mem:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
14<br>
-/+ buffers/cache:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15<br>
Swap:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15<br>
[root@s8-mysd-2 8.4SS]# <br>
<br>
<br>
Now when my job finishes and I close the Connections from 2 Servers ,
the top &amp; free output remains the same :-<br>
<br>
I don't know What is the reason behind this as I have only 3
Connections from the below command :<br>
<br>
postgres=# select datname, client_addr,current_query from
pg_stat_activity;<br>
&nbsp;&nbsp;&nbsp; datname&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; client_addr&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
current_query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
----------------+---------------+------------------------------------------------------------------<br>
&nbsp;postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | select datname,
client_addr,current_query from pg_stat_activity;<br>
&nbsp;postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 192.168.0.208 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_s9&nbsp;&nbsp;&nbsp; | 192.168.0.208 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_s9&nbsp;&nbsp;&nbsp; | 192.168.0.208 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_dummy | 192.168.0.208 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_dummy | 192.168.1.102 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_dummy | 192.168.1.102 | &lt;IDLE&gt;<br>
&nbsp;pdc_uima_dummy | 192.168.1.102 | &lt;IDLE&gt;<br>
(8 rows)<br>
<br>
<br>
PLease help me to understand how much memory does 1 Connection Uses and
how to use Server parameters accordingly.<br>
<br>
<br>
Thanks &amp; best Regards,<br>
Adarsh Sharma<br>
<br>
<br>
<br>
Raghavendra wrote:
<blockquote
 cite="mid:BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com"
 type="cite">Adarsh,
  <div><br>
  </div>
  <div>What is the Size of Database?</div>
  <div>
  <div><br>
  </div>
  <div>Best Regards,<br>
Raghavendra<br>
EnterpriseDB Corporation</div>
  <div><br>
  </div>
  <div class="gmail_quote">On Mon, Apr 4, 2011 at 4:24 PM, Scott
Marlowe <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt;</span>
wrote:<br>
  <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
    <div class="im">On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe &lt;<a
 moz-do-not-send="true" href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt;
wrote:<br>
&gt;<br>
&gt;&gt; [root@s8-mysd-2 ~]# free &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;total &nbsp; &nbsp; &nbsp; used &nbsp; &nbsp; &nbsp;
free &nbsp; &nbsp; shared<br>
&gt;&gt; &nbsp; &nbsp;buffers &nbsp; &nbsp; cached<br>
&gt;&gt; Mem: &nbsp; &nbsp; &nbsp;16299476 &nbsp; 16202264 &nbsp; &nbsp; &nbsp;97212 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp;58924
&nbsp; 15231852<br>
&gt;&gt; -/+ buffers/cache: &nbsp; &nbsp; 911488 &nbsp; 15387988<br>
&gt;&gt; Swap: &nbsp; &nbsp; 16787884 &nbsp; &nbsp; 153136 &nbsp; 16634748<br>
&gt;<br>
&gt; There is nothing wrong here. &nbsp;You're using 153M out of 16G swap.
&nbsp;15.x<br>
&gt; Gig is shared buffers. &nbsp;If your system is slow, it's not because
it's<br>
&gt; running out of memory or using too much swap.<br>
    <br>
    </div>
Sorry that's 15.xG is system cache, not shared buffers. &nbsp;Anyway, still<br>
not a problem.<br>
    <div>
    <div class="h5"><br>
--<br>
Sent via pgsql-performance mailing list (<a moz-do-not-send="true"
 href="mailto:pgsql-performance@postgresql.org">pgsql-performance@postgresql.org</a>)<br>
To make changes to your subscription:<br>
    <a moz-do-not-send="true"
 href="http://www.postgresql.org/mailpref/pgsql-performance"
 target="_blank">http://www.postgresql.org/mailpref/pgsql-performance</a><br>
    </div>
    </div>
  </blockquote>
  </div>
  <br>
  </div>
</blockquote>
<br>
</body>
</html>

--------------050101010002010909000501--