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

Re: postgres: 100% CPU utilization

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Sergey Tsukinovsky" <Sergey(dot)Tsukinovsky(at)cryptologic(dot)com>
Subject: Re: postgres: 100% CPU utilization
Date: 2007-04-23 08:53:38
Message-ID: 200704231053.38952.mweilguni@sime.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

Best regards
Mario Weilguni

In response to

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-04-23 09:46:45
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command
Previous:From: Michael FuhrDate: 2007-04-23 08:45:58
Subject: Re: Help with TOAST Compression

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