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 81E89D1D52E; Fri, 23 Apr 2004 11:13:57 -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 29080-09; Fri, 23 Apr 2004 11:13:59 -0300 (ADT) Received: from cri.ensmp.fr (orgenoy.ensmp.fr [193.48.171.195]) by svr1.postgresql.org (Postfix) with ESMTP id 9919BD1D370; Fri, 23 Apr 2004 11:13:54 -0300 (ADT) Received: from sablons.cri.ensmp.fr (sablons.cri.ensmp.fr [10.2.14.143]) by cri.ensmp.fr (8.11.2/8.11.2/mx-cri-CRI) with ESMTP id i3NEDq202284; Fri, 23 Apr 2004 16:13:52 +0200 (MEST) Date: Fri, 23 Apr 2004 16:13:52 +0200 (CEST) From: Fabien COELHO Reply-To: Fabien COELHO To: "Matthew T. O'Connor" Cc: PostgreSQL-development , PostgreSQL advocacy Subject: Re: [HACKERS] What can we learn from MySQL? In-Reply-To: <58232.192.154.91.225.1082725121.squirrel@192.154.91.225> Message-ID: References: <200404230409.i3N49jC02890@candle.pha.pa.us> <58232.192.154.91.225.1082725121.squirrel@192.154.91.225> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/215 X-Sequence-Number: 4187 Dear Matthew, > 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 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. Good luck;-) -- Fabien Coelho - coelho@cri.ensmp.fr