Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id DA06F9FB665
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 23 Apr 2007 05:53:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 80429-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 23 Apr 2007 05:53:21 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from relay.icomedias.com (relay.icomedias.com [62.99.232.66])
	by postgresql.org (Postfix) with ESMTP id BAD359FB2F8
	for <pgsql-performance@postgresql.org>;
	Mon, 23 Apr 2007 05:53:23 -0300 (ADT)
Received: from [10.192.17.128] ([10.192.17.128])
	by relay.icomedias.com (8.13.7/8.13.7) with ESMTP id l3N8rJDn017062;
	Mon, 23 Apr 2007 10:53:19 +0200
From: Mario Weilguni <mweilguni@sime.com>
To: pgsql-performance@postgresql.org
Subject: Re: postgres: 100% CPU utilization
Date: Mon, 23 Apr 2007 10:53:38 +0200
User-Agent: KMail/1.9.6
Cc: "Sergey Tsukinovsky" <Sergey.Tsukinovsky@cryptologic.com>
References: 
 <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
In-Reply-To: 
 <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200704231053.38952.mweilguni@sime.com>
X-Scanned-By: MIMEDefang 2.57 on 10.192.64.104
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/387
X-Sequence-Number: 24264

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