pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jean-Michel POURE <jmpoure@translationforge.com>
To: valeria@saolucas-se.com.br
Cc: pgsql-php@postgresql.org
Subject: Re: PERFORMANCE
Date: Thu, 18 Apr 2002 22:17:05 +0200
Message-ID: <200204182217.06005.jmpoure@translationforge.com> (raw)
In-Reply-To: <2263.192.168.1.205.1019159695.squirrel@www.saolucas-se.com.br>
References: <200204181017.56709.jmpoure@translationforge.com>
	<2263.192.168.1.205.1019159695.squirrel@www.saolucas-se.com.br>

Le Jeudi 18 Avril 2002 21:54, valeria@saolucas-se.com.br a écrit :
> Top result when the server is almost stoping ...
>
> 4:19pm  up 2 days,  3:04,  2 users,  load average: 4.26, 4.06, 4.59
> 102 processes: 96 sleeping, 6 running, 0 zombie, 0 stopped
> CPU0 states: 83.0% user, 15.0% system,  0.0% nice,  0.1% idle
> CPU1 states: 82.0% user, 16.0% system,  0.0% nice,  0.1% idle
> Mem:  771384K av, 699676K used,  71708K free,       0K shrd,    6488K buff
> Swap:  522232K av,   77420K used,  444812K free

Load avarage is 4.26. A large query seems to overflow the system.
Type command "top" to make sure PostgreSQL is really at stake.

Then, modify /etc/init.d/postgresql to run PostgreSQL in debug mode:
postmaster ... -d debug-level 

Restart PostgreSQL service entering: 
"service postgresql restart"

This will log all queries and may help you understand what is going on.

Best regards,
Jean-Michel POURE



view thread (13+ messages)  latest in thread

Message-ID: <200204182217.06005.jmpoure@translationforge.com>
Permalink:  ../200204182217.06005.jmpoure@translationforge.com/
Also on:    postgresql.org/message-id/200204182217.06005.jmpoure@translationforge.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: jmpoure@translationforge.com, valeria@saolucas-se.com.br
  Subject: Re: PERFORMANCE
  In-Reply-To: <200204182217.06005.jmpoure@translationforge.com>
  References: <200204181017.56709.jmpoure@translationforge.com> <2263.192.168.1.205.1019159695.squirrel@www.saolucas-se.com.br> <200204182217.06005.jmpoure@translationforge.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox