Problem - Postgres Running continously - Mailing list pgsql-general

Dear sir,

        i have one problem in postgres and could u
help me in this regard.?

        i am relatively new guy to postgres. since
the guy who handled the postgres is not available.
i'm forced to look into postgres.

        Here is the problem, the postgres server
does't stop after certain time [ the query is execuing
for long time ],it's running forever and eating lot of
memory [ up to 18 MB in RAM], so the machine [ also
running httpd ] is become slow. it cannot serve pages
fastly.

        i'm using postgres 6.4, perl scripts [ DBI/DBD
], linux redhat 6.0, [ 128 MB Ram ]

        the postmaster is started as

        $ postmaster -i -S -B 3000

i don't know where the problem lies, is the query is
wrong?, or i'm often connecting postgres thru PERL
DBI,is it wrong? or the database is corrupted.?


   I really appreciate if u say anything needful

Very Thanks.

Sincerely,
Ned.


        the facts and states of my server is

$ uname -a

Linux saregama 2.2.5-15 #1 Mon Apr 19 21:39:28 EDT
1999 i686 unknown

$ top

  2:44pm  up 101 days,  7:05,  1 user,  load average:
30.69, 30.24, 27.92
78 processes: 45 sleeping, 33 running, 0 zombie, 0
stopped
CPU states: 97.0% user,  2.9% system,  0.0% nice,
0.0% idle
Mem:  128028K av,  99996K used,  28032K free, 614976K
shrd,   2840K buff
Swap: 128484K av,  19764K used, 108720K free
      52488K cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT  LIB %CPU
%MEM   TIME COMMAND
 6652 postgres  20   0 20644  20M 20124 R       0  7.4
16.0   0:48 postmaster
 6714 postgres  16   0 20524  19M 20000 R       0  5.5
15.9   0:42 postmaster
 5122 postgres  20   0 21256  20M 20696 R       0  4.7
16.2   3:23 postmaster
 5209 postgres  10   0 21216  20M 20676 R       0  4.3
16.2   3:13 postmaster
 6382 postgres  10   0 20608  19M 20040 R       0  4.3
15.7   1:08 postmaster
 6721 postgres  10   0 22128  21M 21612 R       0  4.3
17.2   0:42 postmaster
 5029 postgres  10   0 21212  20M 20664 R       0  4.1
16.2   3:39 postmaster
 5043 postgres  10   0 21212  20M 20656 R       0  4.1
16.2   3:39 postmaster
 5056 postgres  10   0 21216  20M 20672 R       0  4.1
16.2   3:33 postmaster
 6186 postgres  10   0 21136  20M 20572 R       0  4.1
16.1   1:21 postmaster
 6651 postgres  10   0 20688  20M 20168 R       0  4.1
16.1   0:48 postmaster
 7253 saregama  10   0  2064 2064   992 R       0  4.1
 1.6   0:00 saregama
 6339 postgres  10   0 20844  19M 20284 R       0  3.9
15.9   1:08 postmaster
 7254 saregama  10   0  2064 2064   992 R       0  3.9
 1.6   0:00 saregama
 7030 postgres  10   0 18888  18M 18368 R       0  3.7
14.7   0:18 postmaster
 5025 postgres   9   0 21212  20M 20660 R       0  3.5
16.2   3:43 postmaster
 5079 postgres   9   0 21212  20M 20656 R       0  3.3
16.2   3:34 postmaster
 6214 postgres  10   0 21212  20M 20656 R       0  3.3
16.2   1:14 postmaster
 3991 postgres  10   0 21412  20M 20716 R       0  3.1
16.3  21:48 postmaster
 4549 postgres  10   0 21208  20M 20664 R       0  3.1
16.2   9:51 postmaster
 5232 postgres  15   0 21212  20M 20668 R       0  2.9
16.2   3:12 postmaster
 4879 postgres   9   0 21212  20M 20652 R       0  2.7
16.2   5:24 postmaster
 6483 postgres   9   0 21204  20M 20644 R       0  2.7
16.2   0:50 postmaster
 6991 postgres   9   0 19572  19M 19052 R       0  2.3
15.2   0:20 postmaster
 7255 root      10   0   892  892   640 R       0  1.7
 0.6   0:00 xkbcomp




$ ps xafw

2832 ?        S      0:00 postmaster -i -S -B 2500
 3991 ?        R     21:38  \_ [postmaster]
 4549 ?        R      9:41  \_ [postmaster]
 4557 ?        R      9:03  \_ [postmaster]
 4879 ?        R      5:14  \_ [postmaster]
 4916 ?        R      4:33  \_ [postmaster]
 5025 ?        R      3:33  \_ [postmaster]
 5029 ?        R      3:29  \_ [postmaster]
 5043 ?        R      3:29  \_ [postmaster]
 5056 ?        R      3:23  \_ [postmaster]
 5079 ?        R      3:23  \_ [postmaster]
 5122 ?        R      3:13  \_ [postmaster]
 5193 ?        R      3:04  \_ [postmaster]
 5209 ?        R      3:03  \_ [postmaster]
 5232 ?        R      3:02  \_ [postmaster]
 6184 ?        R      1:10  \_ [postmaster]
 6186 ?        R      1:11  \_ [postmaster]
 6214 ?        R      1:04  \_ [postmaster]
 6339 ?        R      0:58  \_ [postmaster]
 6373 ?        R      0:51  \_ [postmaster]
 6382 ?        R      0:57  \_ [postmaster]
 6483 ?        R      0:40  \_ [postmaster]
 6651 ?        R      0:38  \_
/usr/local/pgsql/bin/postgres localhost yantra rp
 6652 ?        R      0:38  \_
/usr/local/pgsql/bin/postgres localhost yantra rp
 6714 ?        R      0:32  \_
/usr/local/pgsql/bin/postgres localhost yantra rp
 6721 ?        R      0:32  \_
/usr/local/pgsql/bin/postgres localhost postgres
 6766 ?        R      0:28  \_
/usr/local/pgsql/bin/postgres localhost yantra rp
 6962 ?        R      0:13  \_
/usr/local/pgsql/bin/postgres localhost postgres
 6991 ?        R      0:10  \_
/usr/local/pgsql/bin/postgres localhost yantra rp
 7030 ?        R      0:07  \_
/usr/local/pgsql/bin/postgres localhost yantra rp


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com