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
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,
> 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
In response to
pgsql-performance by date
|Next:||From: Jeremy Harris||Date: 2008-06-23 13:36:28|
|Subject: Re: Postgresql is very slow|
|Previous:||From: bijayant kumar||Date: 2008-06-23 11:06:54|
|Subject: Postgresql is very slow|