Skip site navigation (1) Skip section navigation (2)

Memory problems

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Memory problems
Date: 2002-07-22 20:38:30
Message-ID: OF51FEA3F8.07B98384-ON88256BFE.006F86CE-88256BFE.00716236@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
I'm not sure if this is the correct forum to ask this question, but here it
is:
Pg version: 7.2.1
OS - RedHat 7.2
ODBC - 7.2.1 Dual Processor
Memory - 512mg

I have a VB   app I created that will display a Crystal report within its
ActiveX control.  The Crystal report will call an ODBC DSN on the user
desktop that will populate the report.  After the data is returned, and the
connection status is IDLE, the memory usage for the connection according to
Top is 24.5% of memory usage.  Does this sound right?  Nothing is happening
during the idle state, so why would the memory usuage be so high?
Here's a copy of the running process with a user name of Postgres.  Note
that the mcom_users are all connected via  ODBC and the cjoarers are JDBC.
TIA
-patrick

48 processes: 47 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states:  0.0% user,  0.0% system,  0.0% nice, 100.0% idle
CPU1 states:  0.0% user,  0.2% system,  0.0% nice, 99.3% idle
Mem:   512924K av,  506488K used,    6436K free,  123460K shrd,    4736K
buff
Swap: 1048536K av,   60400K used,  988136K free                  294188K
cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
 5159 postgres   9   0  122M 122M  121M S     0.0 24.5   1:31 postgres:
mcom_user mdc_oz someIP_1idle
 5498 postgres   9   0 97728  95M 96536 S     0.0 19.0   0:03 postgres:
mcom_user mdc_oz someIP_2 idle
 5113 postgres   9   0 84668  82M 83492 S     0.0 16.4   1:08 postgres:
mcom_user mdc_oz someIP_3 idle
 5608 postgres   9   0 84656  82M 83532 S     0.0 16.4   0:05 postgres:
mcom_user mdc_oz someIP_4 idle
 5685 postgres   9   0 15864  15M 14928 S     0.0  3.0   0:00 postgres:
cjoarder mdc_oz someIP_5 idle
 5311 postgres   9   0 13748  13M 12932 S     0.0  2.6   0:00 postgres:
cjoarder mdc_oz someIP_6 idle
30127 postgres   9   0  1552 1180  1180 S     0.0  0.2   0:00 postgres:
cjoarder mdc_oz someIP_7 idle
13251 postgres   9   0   524  240   240 S     0.0  0.0   0:00 postgres:
stats collector process
30129 postgres   9   0   956  204   204 S     0.0  0.0   0:00 postgres:
cjoarder mdc_oz someIP_8 idle
13248 postgres   8   0   464  200   168 S     0.0  0.0   0:02
/usr/bin/postmaster
30128 postgres   9   0   948  196   196 S     0.0  0.0   0:00 postgres:
cjoarder mdc_oz someIP_9 idle
13250 postgres   9   0   484   72    48 S     0.0  0.0   0:00 postgres:
stats buffer process





Responses

pgsql-novice by date

Next:From: Andrew McMillanDate: 2002-07-22 21:05:07
Subject: Re: Memory problems
Previous:From: Nigel J. AndrewsDate: 2002-07-22 20:27:55
Subject: Re: URGENT! pg_dump doesn't work!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group