| From: | Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Some problem on the data base server ! |
| Date: | 2000-11-20 10:28:22 |
| Message-ID: | 20001120112822.A28021@apr-job.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(dot)jouanne(at)humanline(dot)fr
-*- If Linux doesn't have the solution, you have the wrong problem -*-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olivier Cherrier | 2000-11-20 10:33:10 | pgaccess |
| Previous Message | rwk | 2000-11-20 09:44:36 | Backward Compatibility |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc SCHAEFER | 2000-11-20 11:12:48 | Re: Some problem on the data base server ! |
| Previous Message | Fawad Halim | 2000-11-19 23:21:15 | postmaster doesn't work with UNIX sockets |