X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id C99B8D1BB89; Fri, 23 Apr 2004 11:37:06 -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 42889-02; Fri, 23 Apr 2004 11:37:09 -0300 (ADT)
Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171])
	by svr1.postgresql.org (Postfix) with ESMTP
	id B7086D1BA93; Fri, 23 Apr 2004 11:37:04 -0300 (ADT)
Received: from ool-4352919e.dyn.optonline.net ([67.82.145.158]
	helo=matth.zeut.net) by outbound.mailhop.org with asmtp (Exim 4.20)
	id 1BH1nZ-000EoN-Fp; Fri, 23 Apr 2004 10:37:01 -0400
Received: from 192.154.91.225 (SquirrelMail authenticated user dbmail2user);
	by matth.zeut.net with HTTP; Fri, 23 Apr 2004 09:37:32 -0400 (EDT)
Message-ID: <50773.192.154.91.225.1082727452.squirrel@192.154.91.225>
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>
Date: Fri, 23 Apr 2004 09:37:32 -0400 (EDT)
Subject: Re: [HACKERS] What can we learn from MySQL?
From: "Matthew T. O'Connor" <matthew@zeut.net>
To: "Fabien COELHO" <coelho@cri.ensmp.fr>
Cc: "Matthew T. O'Connor" <matthew@zeut.net>,
	"PostgreSQL-development" <pgsql-hackers@postgresql.org>,
	"PostgreSQL advocacy" <pgsql-advocacy@postgresql.org>
User-Agent: SquirrelMail/1.5.0
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3
Importance: Normal
X-Mail-Handler: MailHop Outbound by DynDNS.org
X-Report-Abuse-To: abuse@dyndns.org
X-MHO-User: Zeut
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0
	tests=PRIORITY_NO_NAME, RCVD_IN_NJABL, RCVD_IN_SORBS
X-Spam-Level: *
X-Archive-Number: 200404/219
X-Sequence-Number: 4191

>> My goal is to have pg_autovacuum integrated into the backend for 7.5.
>
> I know about that, and that would be a good thing.

I hope so!

>> I don't know if it will default to being turned on or off, I'm sure that
>> will be a discussion, but if it is defaulted to on, then this whole
>> problem of having to train newbies about vacuum should just go away.
>
> 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.

I think it's premature to have this conversation.  I need to get something
done / working before we dicuss optimal configuration.  That said, I also
agree that if it's good enough, it should be on by default.

> Good luck;-)

Thanks, I'll need it....

Matthew

ps: I'm hoping to have time to work on this starting in May.  I haven't
really done any development on pg_autovacuum beyond bug fixing what is
already in CVS, so.... If someone out there wants to work on it, don't
wait for me, I won't be offended :-)  I just want to see it up and
running.