Problem - Postgres Running continously

From: Nedu <neduma(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problem - Postgres Running continously
Date: 2000-02-25 13:54:13
Message-ID: 20000225135413.20880.qmail@web120.yahoomail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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

Browse pgsql-sql by date

  From Date Subject
Next Message Emils Klotins 2000-02-25 13:59:40 INSERT w/o variable names for a SERIAL type?
Previous Message Moray McConnachie 2000-02-25 11:16:10 Re: [SQL] how to create index on timestamp field in pre v7 database