Re: [HACKERS] posmaster failed under high load

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: 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 03:56:58
Message-ID: Pine.GSO.3.96.SK.990505075531.8464C-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 1999-05-05 06:38:27 Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again)
Previous Message Hiroshi Inoue 1999-05-05 02:17:05 RE: [HACKERS] I'm planning some changes in lmgr...