Re: Some problem on the data base server !

From: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>
To: Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Some problem on the data base server !
Date: 2000-11-20 11:12:48
Message-ID: Pine.LNX.3.96.1001120121126.1681C-100000@defian.alphanet.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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.

> '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.

> "CPU states: 95.1% user, 4.9% system, 0.0% nice, 59619.1% idle"

How is using the 95.1% of CPU ?

> is it normal ?

no, the 59619 value looks like a bug in top, or a mismatching kernel
version.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mickaël Jouanne 2000-11-20 11:29:52 Re: [NOVICE] Re: Some problem on the data base server !
Previous Message Olivier Cherrier 2000-11-20 10:33:10 pgaccess

Browse pgsql-novice by date

  From Date Subject
Next Message Mickaël Jouanne 2000-11-20 11:29:52 Re: [NOVICE] Re: Some problem on the data base server !
Previous Message Mickaël Jouanne 2000-11-20 10:28:22 Some problem on the data base server !