On Mon, Nov 20, 2000 at 12:12:48PM +0100, Marc SCHAEFER wrote:
> On Mon, 20 Nov 2000, Mickaël Jouanne wrote:
>
> > We had a database server on Mysql and we move to postgres last month.
>
> Not enough. You need to specify the exact version, and also the version of
> your operating system. Let's assume Linux.
>
i have a
Linux Mandrake release 7.1 (helium)
Kernel 2.2.17 on a Bi-processor i686
and postgres 7.0.2
> > 'load average: 3.23' or some times higher than that.
>
> Who is responsible for that load ? Remember that on Linux, processes
> waiting for I/Os are also augmenting the load average.
>
there is only postmaster on the server so it's just query that make this load !
> > "CPU states: 95.1% user, 4.9% system, 0.0% nice, 59619.1% idle"
>
> How is using the 95.1% of CPU ?
>
i don't know !
> > is it normal ?
>
> no, the 59619 value looks like a bug in top, or a mismatching kernel
> version.
>
--
Mickaël JOUANNE
Webmaster / Developpeur / Support Technique
APR-Job & www.jobscout24.fr - Meet your future
___________ _______________________________________________ __________
HumanLine France SAS Tel: +33 1 42 44 40 73
32, rue Pierret Fax: +33 1 49 26 09 76
92200 Neuilly m.jouanne@humanline.fr
-*- If Linux doesn't have the solution, you have the wrong problem -*-
