Re: [HACKERS] posmaster failed under high load - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [HACKERS] posmaster failed under high load
Date
Msg-id Pine.GSO.3.96.SK.990505075531.8464C-100000@ra
Whole thread Raw
In response to Re: [HACKERS] posmaster failed under high load  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] posmaster failed under high load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 4 May 1999, Bruce Momjian wrote:

> Date: Tue, 4 May 1999 21:35:56 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: Tatsuo Ishii <t-ishii@sra.co.jp>, hackers@postgreSQL.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/postgreslocalhost httpd apod idle 5169  ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd
apodidle 5170  ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd apod idle 5171  ?  S    0:00
/usr/local/pgsql/bin/postgreslocalhost 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@candle.pha.pa.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] I'm planning some changes in lmgr...
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again)