Re: [NOVICE] Re: Some problem on the data base server !

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(dot)jouanne(at)humanline(dot)fr

-*- If Linux doesn't have the solution, you have the wrong problem -*-