pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
To: Benjamin Bostow <ben@viatornetworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High Processor consumption
Date: Wed, 19 Nov 2003 12:04:12 +0530
Message-ID: <3FBB0EE4.6010805@myrealbox.com> (raw)
In-Reply-To: <1069204784.1955.16.camel@localhost.localdomain>
References: <1069204784.1955.16.camel@localhost.localdomain>

Benjamin Bostow wrote:

> I am running RH 7.3 running Apache 1.3.27-2 and PostgreSQL 7.2.3-5.73.
> When having 100+ users connected to my server I notice that postmaster
> consumes up wards of 90% of the processor and I hardly am higher than
> 10% idle. I did notice that when I kill apache and postmaster that my
> idle processor percentage goes to 95% or higher. I am looking on ways
> that I can find what connections are making the database processes run
> so high. If this could also tell which program is accessing it, it would
> be helpful. I have look through the documents on performance tuning
> postgresql and have adjusted my memory with little effect. I have even
> routed all traffic away from the Apache server so no load is on apache.
> I do have C programs that run and access the database. Any help will be
> greatly appreciated. 

Routinely the CPU load for postgresql translates to too much low shared buffers 
setting for requirement.

What are your postgresql.conf tunings? Could you please post them?

  Shridhar




view thread (3+ messages)  latest in thread

Message-ID: <3FBB0EE4.6010805@myrealbox.com>
Permalink:  ../3FBB0EE4.6010805@myrealbox.com/
Also on:    postgresql.org/message-id/3FBB0EE4.6010805@myrealbox.com

 · 

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: shridhar_daithankar@myrealbox.com, ben@viatornetworks.com
  Subject: Re: High Processor consumption
  In-Reply-To: <3FBB0EE4.6010805@myrealbox.com>

* 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