pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Benjamin Bostow <ben@viatornetworks.com>
To: pgsql-performance@postgresql.org
Subject: High Processor consumption
Date: 18 Nov 2003 18:19:14 -0700
Message-ID: <1069204784.1955.16.camel@localhost.localdomain> (raw)


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. 

Thanks in advance,
Ben






view thread (3+ messages)  latest in thread

Message-ID: <1069204784.1955.16.camel@localhost.localdomain>
Permalink:  ../1069204784.1955.16.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1069204784.1955.16.camel@localhost.localdomain

 · 

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: ben@viatornetworks.com
  Subject: Re: High Processor consumption
  In-Reply-To: <1069204784.1955.16.camel@localhost.localdomain>

* 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