Skip site navigation (1) Skip section navigation (2)

Re: postgres: 100% CPU utilization

From: "Sergey Tsukinovsky" <Sergey(dot)Tsukinovsky(at)cryptologic(dot)com>
To: "Ron" <rjpeace(at)earthlink(dot)net>,"Mario Weilguni" <mweilguni(at)sime(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgres: 100% CPU utilization
Date: 2007-04-24 15:30:05
Message-ID: 2C20E65455FC964690D89F8C4A2E9B1D03ABA7F9@STRAIGHTFLUSH.cryptologic.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks for this reply, Ron.
This is almost what I was looking for.

While the upgrade to the latest version is out of the question (which
unfortunately for me became the subject of this discussion) still, I was
looking for the ways to improve the performance of the 7.0.2 version. 

Extensive use of vacuum was almost obvious, though I was hoping to get
some more tips from postrges gurus (or dinosaurs, if you want).

Anyways, the 8.2.4 was not performing so well without auto-vacuum. It
ramped up to 50% of CPU usage in 2 hours under the load.
With the auto-vacuum ON I've got what I really need and thus I know what
to do next.

Just for the record - the hardware that was used for the test has the
following parameters:
AMD Opteron 2GHZ
2GB RAM
LSI Logic SCSI

Thanks everyone for your assistance!
Sergey




-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Ron
Sent: Monday, April 23, 2007 11:07 AM
To: Mario Weilguni
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] postgres: 100% CPU utilization

At 04:53 AM 4/23/2007, Mario Weilguni wrote:
>Am Donnerstag, 19. April 2007 schrieb Sergey Tsukinovsky:
> > 2. What would be the recommended set of parameters to tune up in
order
> > to improve the performance over the time, instead of considering an
> > option to vacuum every 30 minutes or so?
> >
> > 3. Is it safe to run 'vacuum' as frequently as every 15-30 minutes?
>No problem.
>
> >
> > 4. Suggestions?
>Do yourself a favor and upgrade at least to 8.1.x and use autovacuum.
In fact, I'll go one step further and say that pg improves so much 
from release to release that everyone should make superhuman efforts 
to always be running the latest stable release.

Even the differences between 8.1.x and 8.2.x are worth it.

(and the fewer and more modern the releases "out in the wild", the 
easier community support is)
Cheers,
Ron Peacetree 


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

In response to

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2007-04-24 15:41:43
Subject: Re: View is not using a table index
Previous:From: Dan SheaDate: 2007-04-24 15:17:14
Subject: View is not using a table index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group