X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 15685D1B441 for ; Sat, 6 Dec 2003 19:42:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66287-03 for ; Sat, 6 Dec 2003 15:41:49 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 24950D1B481 for ; Sat, 6 Dec 2003 15:41:47 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 1133C1E12; Sat, 6 Dec 2003 14:41:41 -0500 (EST) To: LIANHE SHAO Cc: pgsql-performance Subject: Re: query using cpu nearly 100%, why? From: Neil Conway In-Reply-To: <19be88196606.19660619be88@jhmimail.jhmi.edu> (LIANHE SHAO's message of "Fri, 05 Dec 2003 13:03:42 -0800") References: <19be88196606.19660619be88@jhmimail.jhmi.edu> Date: Sat, 06 Dec 2003 14:41:36 -0500 Message-ID: <8765gt91jj.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/142 X-Sequence-Number: 5002 LIANHE SHAO writes: > Hello, I use php as front-end to query our database. When I use > System Monitor to check the usage of cpu and memory, I noticed that > the cpu very easily gets up to 100%. Is that normal? if not, could > someone points out possible reason? You haven't given us nearly enough information about the problem to allow us to provide any meaningful advice. -Neil