Some problem on the data base server !

Поиск
Список
Период
Сортировка
От Mickaël Jouanne
Тема Some problem on the data base server !
Дата
Msg-id 20001120112822.A28021@apr-job.com
обсуждение исходный текст
Ответы Re: [GENERAL] Some problem on the data base server !
Список 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 по дате отправления:

Предыдущее
От: Fawad Halim
Дата:
Сообщение: postmaster doesn't work with UNIX sockets
Следующее
От: Marc SCHAEFER
Дата:
Сообщение: Re: [GENERAL] Some problem on the data base server !