pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Willo van der Merwe <willo@studentvillage.co.za>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL performance issues
Date: Wed, 30 Aug 2006 13:35:20 +0200
Message-ID: <44F577F8.5070307@studentvillage.co.za> (raw)
In-Reply-To: <3E37B936B592014B978C4415F90D662D04392D1A@MI8NYCMAIL06.Mi8.com>
References: <3E37B936B592014B978C4415F90D662D04392D1A@MI8NYCMAIL06.Mi8.com>

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.

view thread (23+ messages)  latest in thread

Message-ID: <44F577F8.5070307@studentvillage.co.za>
Permalink:  ../44F577F8.5070307@studentvillage.co.za/
Also on:    postgresql.org/message-id/44F577F8.5070307@studentvillage.co.za

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: willo@studentvillage.co.za, LLonergan@greenplum.com, mmoncure@gmail.com
  Subject: Re: PostgreSQL performance issues
  In-Reply-To: <44F577F8.5070307@studentvillage.co.za>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox