DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:to:subject:date:user-agent:references:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:message-id:sender;
	b=ekoEYpSnBOURt7cp0zAsc+B9qSB1R2Yt64sD6zkuzwrJcU61uepQXPRSyJ9OgWjWCt
	XgX930cR3NhwJf/cN2b5oma0Rll4kdzSDLPRf6+7OTDRDX0+4jpQIImnQ9HQCb8U3DUW
	d8/7SgWQU8zk9J24RkG4lJgC+M6V7rdivGWYE=
From: Jan de Visser <jdevisser@digitalfairway.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql is very slow
Date: Mon, 23 Jun 2008 08:35:58 -0400
User-Agent: KMail/1.9.9
References: <306870.66258.qm@web32707.mail.mud.yahoo.com>
In-Reply-To: <306870.66258.qm@web32707.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200806230835.58375.jdevisser@digitalfairway.com>

On Monday 23 June 2008 07:06:54 bijayant kumar wrote:
> Hello to list,
>
> We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling
> with postgresql performance. Any query say select * from tablename takes
> 10-15 mins to give the output, and while executing the query system loads
> goes up like anything. After the query output, system loads starts
> decresing.

Sounds like a vacuum problem.

>
> Any query select,insert,update simple or complex behaves in the same way,
> what i have explained above.
>
> System Specification:
>
> OS :- CentOs 5
> Postgresql 8.1.8
> RAM :- 1 GB
> SWAP 2 GB
>
> Some relevent part(uncommented) of my  /var/lib/pgsql/data/postgresql.conf
>
> listen_addresses = 'localhost'
> max_connections = 100
> shared_buffers = 1000

You shared_buffers seems low.

>
> The one more strange thing is that with the same setting on another server,
> postgresql is running very smooth. I had run vacum also some times back.

You are aware that vacuum is supposed to be an ongoing maintenance activity, 
right? 

>
> Please help me out and let me know if you need any other information.
>
> Thanks & Regards,
>
> Bijayant Kumar
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com

jan