Re: postmaster has high CPU (system) utilization

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Trevor Bylsma <tbylsma(at)atreus-systems(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster has high CPU (system) utilization
Date: 2003-03-26 16:02:48
Message-ID: j2j38v82ttjd82evncui4trolep6jl6cgp@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17 Mar 2003 18:10:14 -0500, Trevor Bylsma
<tbylsma(at)atreus-systems(dot)com> wrote:
>postmaster will use most of the CPU for an extended amount of time
>(which isn't odd) but 75% of that is system level (which seems odd)...

You have not told us anything about your hardware and operating
system, but if you are running Linux and if you have IDE drives and if
DMA is not enabled, then

hdparm -d 1 /dev/hd<x>

might help.

>Mem: 257136K av, 241656K used, 15480K free, 147956K shrd, 55740K buff

BTW, I hope "147956K shrd" is not exclusively due to Postgres shared
buffers.

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-03-26 16:25:31 Re: Performance tuning in PostgreSQL
Previous Message Dennis Gearon 2003-03-26 15:47:12 Re: Please help with this error message