Re: PostgreSQL performance issues - Mailing list pgsql-performance

From Luke Lonergan
Subject Re: PostgreSQL performance issues
Date
Msg-id 3E37B936B592014B978C4415F90D662D04392D1A@MI8NYCMAIL06.Mi8.com
Whole thread Raw
In response to PostgreSQL performance issues  (Willo van der Merwe <willo@studentvillage.co.za>)
Responses Re: PostgreSQL performance issues  (Willo van der Merwe <willo@studentvillage.co.za>)
List pgsql-performance
> 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


pgsql-performance by date:

Previous
From: Matthew Sullivan
Date:
Subject: performance problems.
Next
From: Willo van der Merwe
Date:
Subject: Re: PostgreSQL performance issues