pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Cheston <ccheston@gmail.com>
To: pgsql-performance@postgresql.org
Subject: postgres 7.4 at 100%
Date: Thu, 24 Jun 2004 23:59:32 -0700
Message-ID: <e071108e04062423591d2b8aa9@mail.gmail.com> (raw)

Hi all,

I was running Postgres 7.3 and it was running at about 15% with my
application. On Postgres 7.4 on another box, it was running at 100%...
My settings are default on both boxes I think.

There are only about 20 inserts per second, which is really low. 
Anyone have any ideas as to something I have to do to Postgres 7.4 to
change it from the default so that it's not eating up all my CPU?  I
have no clue how to debug this...

Help please!!!!  Should I downgrade to 7.3 to see what happens?  BTW
I'm running Postgres 7.3.2 on:

Linux box 2.4.25-040218 #1 SMP Wed Feb 18 17:59:29 CET 2004 i686 i686
i386 GNU/Linux

on a single processor P4 1.4GHz, 512 MB RAM.  Does the SMP kernel do
something with the single processor CPU? or should this not affect
psql?

Thanks in advance!!!
Chris



view thread (24+ messages)  latest in thread

Message-ID: <e071108e04062423591d2b8aa9@mail.gmail.com>
Permalink:  ../e071108e04062423591d2b8aa9@mail.gmail.com/
Also on:    postgresql.org/message-id/e071108e04062423591d2b8aa9@mail.gmail.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: ccheston@gmail.com
  Subject: Re: postgres 7.4 at 100%
  In-Reply-To: <e071108e04062423591d2b8aa9@mail.gmail.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