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