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 D8D59D1B457 for ; Fri, 5 Dec 2003 21:00:57 +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 29329-05 for ; Fri, 5 Dec 2003 17:00:28 -0400 (AST) Received: from jhuml2.jhmi.edu (jhuml2.jhmi.edu [162.129.234.21]) by svr1.postgresql.org (Postfix) with ESMTP id 57BE2D1B482 for ; Fri, 5 Dec 2003 17:00:25 -0400 (AST) Received: from jhuml2.jhmi.edu (jhuml2.jhmi.edu [162.129.234.21]) by jhuml2.jhmi.edu (PMDF V6.2-X17 #30840) with SMTP id <0HPF00EJAWJ081@jhuml2.jhmi.edu> for pgsql-performance@postgresql.org; Fri, 05 Dec 2003 15:59:59 -0500 (EST) Received: from jhuml2.jhmi.edu ([162.129.234.21]) by jhuml2.jhmi.edu (SAVSMTP 3.1.0.29) with SMTP id M2003120515595921657 for ; Fri, 05 Dec 2003 15:59:59 -0500 Received: from jhmimail.jhmi.edu (jhem2.jhmi.edu [162.129.8.23]) by jhuml2.jhmi.edu (PMDF V6.2-X17 #30840) with ESMTP id <0HPF00I0WWZZ3O@jhuml2.jhmi.edu> for pgsql-performance@postgresql.org; Fri, 05 Dec 2003 15:59:59 -0500 (EST) Received: from [162.129.178.57] by jhmimail.jhmi.edu (mshttpd); Fri, 05 Dec 2003 13:03:42 -0800 Date: Fri, 05 Dec 2003 13:03:42 -0800 From: LIANHE SHAO Subject: query using cpu nearly 100%, why? To: pgsql-performance Message-id: <19be88196606.19660619be88@jhmimail.jhmi.edu> MIME-version: 1.0 X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.17 (built Jun 23 2003) Content-type: text/plain; charset=us-ascii Content-language: en Content-transfer-encoding: 7bit Content-disposition: inline X-Accept-Language: en X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/134 X-Sequence-Number: 4994 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? I am using linux7.3, pgsql 7.3.4, 1G Memory and 2GHz CPU. Regards, William