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

Re: postgres: 100% CPU utilization

From: Ron <rjpeace(at)earthlink(dot)net>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres: 100% CPU utilization
Date: 2007-04-23 15:06:32
Message-ID: E1Hg07i-0004wn-Sr@elasmtp-dupuy.atl.sa.earthlink.net (view raw or flat)
Thread:
Lists: pgsql-performance
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 


In response to

Responses

pgsql-performance by date

Next:From: Nelson KotowskiDate: 2007-04-23 15:52:36
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command
Previous:From: Dave DutcherDate: 2007-04-23 14:56:46
Subject: Re: not using indexes on large table

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