I'm guessing you have a 4 cpu box:
1 99 percent busy process on a 4 way box == about 25% busy overall.
On May 5, 2004, at 6:03 AM, Tom Lane wrote:
"Cyrille Bonnet" <[EMAIL PROTECTED]> writes:
Should I be worried that Postgres is eating up 99% of my CPU??? Or is
this
*expected* behaviour?
It's not expected, unless you are running some very long-running query.
The conflict between what top says and what mpstat says is strange; I
wonder if you might have a buggy version of one of them? You should
probably check some other tools (try "vmstat 1" for instance) to see if
you can get a consensus on whether the CPU is maxed out or not ...
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings