Received: from www1.translationforge.com (unknown [212.11.36.58]) by postgresql.org (Postfix) with ESMTP id B2A90475452 for ; Thu, 18 Apr 2002 16:17:06 -0400 (EDT) Received: from linus.translationforge.com ([192.168.1.102]) by www1.translationforge.com (8.12.1/8.12.1) with ESMTP id g3IKH7tb002060; Thu, 18 Apr 2002 22:17:07 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Jean-Michel POURE Reply-To: jmpoure@translationforge.com Organization: Translationforge To: Subject: Re: PERFORMANCE Date: Thu, 18 Apr 2002 22:17:05 +0200 X-Mailer: KMail [version 1.4] References: <200204181017.56709.jmpoure@translationforge.com> <2263.192.168.1.205.1019159695.squirrel@www.saolucas-se.com.br> In-Reply-To: <2263.192.168.1.205.1019159695.squirrel@www.saolucas-se.com.br> Cc: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200204182217.06005.jmpoure@translationforge.com> X-Archive-Number: 200204/63 X-Sequence-Number: 1087 Le Jeudi 18 Avril 2002 21:54, valeria@saolucas-se.com.br a =E9crit : > 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=20 Restart PostgreSQL service entering:=20 "service postgresql restart" This will log all queries and may help you understand what is going on. Best regards, Jean-Michel POURE