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

Re: PostgreSQL performance issues

From: Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL performance issues
Date: 2006-08-30 11:35:20
Message-ID: 44F577F8.5070307@studentvillage.co.za (view raw or flat)
Thread:
Lists: pgsql-performance
Luke Lonergan wrote:
>> Currently the load looks like this:
>> Cpu0  : 96.8% us,  1.9% sy,  0.0% ni,  0.3% id,  0.0% wa,  
>> 0.0% hi,  1.0% si
>> Cpu1  : 97.8% us,  1.6% sy,  0.0% ni,  0.3% id,  0.0% wa,  
>> 0.0% hi,  0.3% si
>> Cpu2  : 96.8% us,  2.6% sy,  0.0% ni,  0.3% id,  0.0% wa,  
>> 0.0% hi,  0.3% si
>> Cpu3  : 96.2% us,  3.2% sy,  0.0% ni,  0.3% id,  0.0% wa,  
>> 0.0% hi,  0.3% si
>>     
>
> All four CPUs are hammered busy - check "top" and look for runaway
> processes.
>
> - Luke
>
>
>   
Yes, the first 463 process are all postgres. In the meanwhile I've done:
Dropped max_connections from 500 to 250 and
Upped shared_buffers = 50000

Without any apparent effect.

In response to

Responses

pgsql-performance by date

Next:From: Luke LonerganDate: 2006-08-30 11:41:51
Subject: Re: PostgreSQL performance issues
Previous:From: Alex HaywardDate: 2006-08-30 11:22:37
Subject: Re: PostgreSQL performance issues

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