Some problem on the data base server !

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