X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id DF4FC9FCF18
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 28 Aug 2006 10:48:00 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 57966-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 28 Aug 2006 10:47:49 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205])
	by postgresql.org (Postfix) with ESMTP id B2A539FCF03
	for <pgsql-performance@postgresql.org>;
	Mon, 28 Aug 2006 10:47:49 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mail.mnc.ch (Postfix) with ESMTP id 46842A82F1;
	Mon, 28 Aug 2006 15:53:09 +0200 (CEST)
Received: from mail.mnc.ch ([127.0.0.1])
	by localhost (mail.test.lan [127.0.0.1]) (amavisd-new,
	port 10025) with ESMTP
	id 13733-10; Mon, 28 Aug 2006 15:53:06 +0200 (CEST)
Received: from meuh.mnc.lan (62-2-77-204.static.cablecom.ch [62.2.77.204])
	by mail.mnc.ch (Postfix) with ESMTP id DA001A82CB;
	Mon, 28 Aug 2006 15:53:06 +0200 (CEST)
Received: by meuh.mnc.lan (Postfix, from userid 1000)
	id 1F0551835C3; Mon, 28 Aug 2006 15:47:42 +0200 (CEST)
To: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: perf pb solved only after pg_dump and restore
References: <8764gd1dkz.fsf@meuh.mnc.lan> <44F2B737.7070301@logix-tt.com>
	<87sljhyz4b.fsf@meuh.mnc.lan>
	<1d4e0c10608280317i4eb9d7d0r2b397845ffb8c19d@mail.gmail.com>
	<874pvxyrbg.fsf@meuh.mnc.lan> <44F2EC0C.7090407@logix-tt.com>
X-Hashcash: 
 1:20:060828:schabi@logix-tt.com::qUdX6CF2MmvgfN7E:0000000000000000000000000000000000000000006Lum
X-Hashcash: 
 1:20:060828:pgsql-performance@postgresql.org::idPfc01uaKwvNeIQ:00000000000000000000000000000365s
From: Guillaume Cottenceau <gc@mnc.ch>
Date: 28 Aug 2006 15:47:42 +0200
In-Reply-To: <44F2EC0C.7090407@logix-tt.com>
Message-ID: <87ac5px98h.fsf@meuh.mnc.lan>
Lines: 18
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: amavisd-new at mnc.ch
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.238 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200608/430
X-Sequence-Number: 20615

Markus Schaber <schabi 'at' logix-tt.com> writes:

> > VACUUM ANALYZE is normally run overnight (each night). Is it not
> > regular enough? There can be hundreds of thousands of statements
> > a day.
> 
> Which PostgreSQL version are you using? Maybe you should consider
> autovacuum (which is a contrib module at least since 7.4, and included
> in the server since 8.1). If you think that vacuum during working hours
> puts too much load on your server, there are options to tweak that, at
> least in 8.1.

Ok, thanks. Unfortunately production insists on sticking on 7.4.5
for the moment :/

-- 
Guillaume Cottenceau
Create your personal SMS or WAP Service - visit http://mobilefriends.ch/