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
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