Some problem on the data base server ! - Mailing list pgsql-novice

From Mickaël Jouanne
Subject Some problem on the data base server !
Date
Msg-id 20001120112822.A28021@apr-job.com
Whole thread Raw
Responses Re: [GENERAL] Some problem on the data base server !
List pgsql-novice
Hello !

We had a database server on Mysql and we move to postgres last month.

But there is problems that i don't understand !
When i runthe "top" command the load average is very high :

'load average: 3.23' or some times higher than that.

And yestaerday i look to a 'top' and i found something strange :

"CPU states: 95.1% user,  4.9% system,  0.0% nice, 59619.1% idle"
                                                  >--------<
is it normal ?

can someone can give me some clues for decreasing the load ?

i perform a VACUUM ANALYSE every day but it can't solve my problems.

Thanx for answers.


--

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 -*-

pgsql-novice by date:

Previous
From: Fawad Halim
Date:
Subject: postmaster doesn't work with UNIX sockets
Next
From: Marc SCHAEFER
Date:
Subject: Re: [GENERAL] Some problem on the data base server !