Re: [HACKERS] posmaster failed under high load

From: Michael Davis <Michael(dot)Davis(at)tvguide(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Bruce Momjian <Maillist(at)Candle(dot)Pha(dot)Pa(dot)Us>, Tatsuo Ishii <T-Ishii(at)Sra(dot)Co(dot)Jp>, Hackers(at)Postgresql(dot)Org
Subject: Re: [HACKERS] posmaster failed under high load
Date: 1999-05-05 14:19:38
Message-ID: 199905051426.KAA75945@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis

From: Oleg Bartunov <oleg @ sai.msu.su> on 05/04/99 11:56 PM
To: Bruce Momjian <maillist @ candle.pha.pa.us>@SMTP(at)EXCHANGE
cc: Tatsuo Ishii <t-ishii @ sra.co.jp>@SMTP(at)EXCHANGE, hackers @
postgreSQL(dot)org(at)SMTP@EXCHANGE
Subject: Re: [HACKERS] posmaster failed under high load

On Tue, 4 May 1999, Bruce Momjian wrote:

> Date: Tue, 4 May 1999 21:35:56 -0400 (EDT)
> From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
> To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
> Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] posmaster failed under high load
>
> > My machine was very-very load during this test - I saw peak
> > load about 65, a lot of swapping but test completes and system
> > after 20 minutes of swapping remains usable. I still saw many
> > postmasters (not postgres) processes running but after about
> > 30-40 minutes they gone. Actually pstree -a now shows
> >
> > |-postmaster -i -B 1024 -S -D/usr/local/pgsql/data/ -o -Fe
> > | |-(postmaster)
> > | `-postmaster
>
> ps should show our process listing display change. They are
postgres
> processes, but without the exec() call we used to do, it shows
this way
> only on OS's that don't support ps arg display changes from inside
the
> process.

No, it does on Linux.
5159 ? S 0:00 postmaster -i -B 1024 -S
-D/usr/local/pgsql/data/ -o -Fe
5168 ? S 0:00 /usr/local/pgsql/bin/postgres localhost httpd
apod idle
5169 ? S 0:00 /usr/local/pgsql/bin/postgres localhost httpd
apod idle
5170 ? S 0:00 /usr/local/pgsql/bin/postgres localhost httpd
apod idle
5171 ? S 0:00 /usr/local/pgsql/bin/postgres localhost httpd
apod idle

That's why I noticed 10 or more (postmaster) processes, which
eventually
gone after 30-40 minutes.

Oleg

>
>
>
> --
> Bruce Momjian |
http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill,
Pennsylvania 19026
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Davis 1999-05-05 14:20:40 Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)
Previous Message Michael Davis 1999-05-05 14:19:09 RE: [HACKERS] I'm planning some changes in lmgr...