From: | Paul Tuckfield <paul(at)tuckfield(dot)com> |
---|---|
To: | Cyrille Bonnet <cyrille(at)3months(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: very high CPU usage in "top", but not in "mpstat" |
Date: | 2004-05-05 18:13:11 |
Message-ID: | DE781E0C-9EBF-11D8-965C-000393BD6C3E@tuckfield.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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" <cyrille(at)3months(dot)com> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | J. Andrew Rogers | 2004-05-05 21:11:29 | Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL |
Previous Message | Richard Huxton | 2004-05-05 18:12:38 | Re: LIKE and INDEX |