Re: Re: [GENERAL] 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.jouanne@humanline.fr

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