| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2006-08-30 11:41:51 | Re: PostgreSQL performance issues |
| Previous Message | Alex Hayward | 2006-08-30 11:22:37 | Re: PostgreSQL performance issues |