From: | Chris Cheston <ccheston(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | postgres 7.4 at 100% |
Date: | 2004-06-25 06:59:32 |
Message-ID: | e071108e04062423591d2b8aa9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-06-25 09:09:51 | Re: postgres 7.4 at 100% |
Previous Message | Mischa Sandberg | 2004-06-24 21:24:58 | Range query optimization |