X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 151F5D1B8BC
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Fri, 23 Apr 2004 17:01:09 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 50399-09
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Fri, 23 Apr 2004 17:01:07 -0300 (ADT)
Received: from servata.com (unknown [64.70.4.194])
	by svr1.postgresql.org (Postfix) with ESMTP id EBDE2D1C4EC
	for <pgsql-hackers@postgresql.org>;
	Fri, 23 Apr 2004 17:01:02 -0300 (ADT)
Received: from [66.27.58.226] (helo=rrcs-west-66-27-58-226.biz.rr.com)
	by servata.com with asmtp (TLS-1.0:RSA_ARCFOUR_MD5:16) (Exim 4.30)
	id 1BH71Q-0002BT-9b; Fri, 23 Apr 2004 13:11:40 -0700
Subject: Re: What can we learn from MySQL?
From: Jeff Davis <jdavis-pgsql@empires.org>
To: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
In-Reply-To: <Pine.LNX.4.58.0404231605480.6454@sablons.cri.ensmp.fr>
References: <200404230409.i3N49jC02890@candle.pha.pa.us>
	<Pine.LNX.4.58.0404230935570.6454@sablons.cri.ensmp.fr>
	<58232.192.154.91.225.1082725121.squirrel@192.154.91.225>
	<Pine.LNX.4.58.0404231605480.6454@sablons.cri.ensmp.fr>
Content-Type: text/plain
Message-Id: <1082750462.32307.1152.camel@jeff>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 
Date: Fri, 23 Apr 2004 13:01:02 -0700
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS
X-Spam-Level: 
X-Archive-Number: 200404/759
X-Sequence-Number: 52681

On Fri, 2004-04-23 at 07:13, Fabien COELHO wrote:

> Yes. I really thing that it should be on by default, because those who
> will need it more than others are those who will not know about tuning
> configuration parameters. As I understand the requirements from
> pg_autovacuum, it means that some statistics will have to be on by default
> as well.
> 

The debian package automatically makes a vacuum entry in the crontab.
So, to a certain extent, this could be solved at the distribution level.

However, the pg_autovacuum project will be a great improvement over
that. Right now, the distributions mostly care about MySQL, so it will
be nice to have postgresql handle that detail.

Jeff