From: David Mitchell <david.mitchell@telogis.com>
To: Dennis <dennis@works4me.com>
Cc: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance problems ... 100 cpu utilization
Date: Thu, 14 Jul 2005 17:07:33 +1200
Message-ID: <42D5F315.3090301@telogis.com> (raw)
In-Reply-To: <42D5DBEB.4010503@works4me.com>
References: <42D567DB.6000100@works4me.com>
<db4l9c$1g4t$1@news.hub.org>
<42D5DBEB.4010503@works4me.com>
What is the load average on this machine? Do you do many updates? If you
do a lot of updates, perhaps you haven't vacuumed recently. We were
seeing similar symptoms when we started load testing our stuff and it
turned out we were vacuuming too infrequently.
David
Dennis wrote:
> Qingqing Zhou wrote:
>
>> Are you sure 100% CPU usage is solely contributed by Postgresql? Also,
>> from
>> the ps status you list, I can hardly see that's a problem because of
>> problem
>> you mentioned below.
>>
>>
> The postgreSQL processes are what is taking up all the cpu. There aren't
> any other major applications on the machine. Its a dedicated database
> server, only for this application.
>
> It doesn't seem to make sense that PostgreSQL would be maxed out at this
> point. I think given the size of the box, it could do quite a bit
> better. So, what is going on? I don't know.
>
> Dennis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
David Mitchell
Software Engineer
Telogis
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: david.mitchell@telogis.com, dennis@works4me.com, zhouqq@cs.toronto.edu
Subject: Re: performance problems ... 100 cpu utilization
In-Reply-To: <42D5F315.3090301@telogis.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