Skip site navigation (1) Skip section navigation (2)

Some problem on the data base server !

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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 -*-

Responses

pgsql-novice by date

Next:From: Marc SCHAEFERDate: 2000-11-20 11:12:48
Subject: Re: Some problem on the data base server !
Previous:From: Fawad HalimDate: 2000-11-19 23:21:15
Subject: postmaster doesn't work with UNIX sockets

pgsql-general by date

Next:From: Olivier CherrierDate: 2000-11-20 10:33:10
Subject: pgaccess
Previous:From: rwkDate: 2000-11-20 09:44:36
Subject: Backward Compatibility

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group