query using cpu nearly 100%, why? - Mailing list pgsql-performance

From LIANHE SHAO
Subject query using cpu nearly 100%, why?
Date
Msg-id 19be88196606.19660619be88@jhmimail.jhmi.edu
Whole thread Raw
Responses Re: query using cpu nearly 100%, why?  (Richard Huxton <dev@archonet.com>)
Re: query using cpu nearly 100%, why?  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
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
thatthe 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


pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Slightly OT -- Xeon versus Opteron Comparison
Next
From: Steve Wampler
Date:
Subject: Help tracking down problem with inserts slowing down...