	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@EXCHANGE
	cc:	Tatsuo Ishii <t-ishii @ sra.co.jp>@SMTP@EXCHANGE, hackers @
postgreSQL.org@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@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/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@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





Wed, 5 May 1999 09:19:38 -0500 
Michael Davis <Michael.Davis@tvguide.com>
Re: [HACKERS] posmaster failed under high load