Problem - Postgres Running continously - Mailing list pgsql-sql

From Nedu
Subject Problem - Postgres Running continously
Date
Msg-id 20000225135413.20880.qmail@web120.yahoomail.com
Whole thread Raw
List pgsql-sql
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 COMMAND6652 postgres  20   0 20644  20M 20124 R       0  7.4
16.0   0:48 postmaster6714 postgres  16   0 20524  19M 20000 R       0  5.5
15.9   0:42 postmaster5122 postgres  20   0 21256  20M 20696 R       0  4.7
16.2   3:23 postmaster5209 postgres  10   0 21216  20M 20676 R       0  4.3
16.2   3:13 postmaster6382 postgres  10   0 20608  19M 20040 R       0  4.3
15.7   1:08 postmaster6721 postgres  10   0 22128  21M 21612 R       0  4.3
17.2   0:42 postmaster5029 postgres  10   0 21212  20M 20664 R       0  4.1
16.2   3:39 postmaster5043 postgres  10   0 21212  20M 20656 R       0  4.1
16.2   3:39 postmaster5056 postgres  10   0 21216  20M 20672 R       0  4.1
16.2   3:33 postmaster6186 postgres  10   0 21136  20M 20572 R       0  4.1
16.1   1:21 postmaster6651 postgres  10   0 20688  20M 20168 R       0  4.1
16.1   0:48 postmaster7253 saregama  10   0  2064 2064   992 R       0  4.11.6   0:00 saregama6339 postgres  10   0
20844 19M 20284 R       0  3.9
 
15.9   1:08 postmaster7254 saregama  10   0  2064 2064   992 R       0  3.91.6   0:00 saregama7030 postgres  10   0
18888 18M 18368 R       0  3.7
 
14.7   0:18 postmaster5025 postgres   9   0 21212  20M 20660 R       0  3.5
16.2   3:43 postmaster5079 postgres   9   0 21212  20M 20656 R       0  3.3
16.2   3:34 postmaster6214 postgres  10   0 21212  20M 20656 R       0  3.3
16.2   1:14 postmaster3991 postgres  10   0 21412  20M 20716 R       0  3.1
16.3  21:48 postmaster4549 postgres  10   0 21208  20M 20664 R       0  3.1
16.2   9:51 postmaster5232 postgres  15   0 21212  20M 20668 R       0  2.9
16.2   3:12 postmaster4879 postgres   9   0 21212  20M 20652 R       0  2.7
16.2   5:24 postmaster6483 postgres   9   0 21204  20M 20644 R       0  2.7
16.2   0:50 postmaster6991 postgres   9   0 19572  19M 19052 R       0  2.3
15.2   0:20 postmaster7255 root      10   0   892  892   640 R       0  1.70.6   0:00 xkbcomp     




$ ps xafw

2832 ?        S      0:00 postmaster -i -S -B 25003991 ?        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 rp6652 ?        R      0:38  \_
/usr/local/pgsql/bin/postgres localhost yantra rp6714 ?        R      0:32  \_
/usr/local/pgsql/bin/postgres localhost yantra rp6721 ?        R      0:32  \_
/usr/local/pgsql/bin/postgres localhost postgres6766 ?        R      0:28  \_
/usr/local/pgsql/bin/postgres localhost yantra rp6962 ?        R      0:13  \_
/usr/local/pgsql/bin/postgres localhost postgres6991 ?        R      0:10  \_
/usr/local/pgsql/bin/postgres localhost yantra rp7030 ?        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


pgsql-sql by date:

Previous
From: "Moray McConnachie"
Date:
Subject: Re: [SQL] how to create index on timestamp field in pre v7 database
Next
From: "Emils Klotins"
Date:
Subject: INSERT w/o variable names for a SERIAL type?