X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 38362D1C4E0 for ; Tue, 5 Aug 2003 15:35:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 16130-07 for ; Tue, 5 Aug 2003 12:34:04 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5DCD5D1CA07 for ; Tue, 5 Aug 2003 12:35:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h75FZ6Sa022889; Tue, 5 Aug 2003 11:35:06 -0400 (EDT) To: "Matthew T. O'Connor" Cc: shridhar_daithankar@persistent.co.in, "Christopher Browne" , pgsql-performance@postgresql.org Subject: Re: Some vacuum & tuning help In-reply-to: <000b01c35b63$22d748d0$c202a8c0@hplaptop> References: <60el00jhyx.fsf@dev6.int.libertyrms.info> <000b01c35b63$22d748d0$c202a8c0@hplaptop> Comments: In-reply-to "Matthew T. O'Connor" message dated "Tue, 05 Aug 2003 11:06:22 -0400" Date: Tue, 05 Aug 2003 11:35:05 -0400 Message-ID: <22888.1060097705@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/71 X-Sequence-Number: 2888 "Matthew T. O'Connor" writes: > I chose to leave pg_autovacuum simple and not add too many features because > the core team has said that it needs to be integrated into the backend > before it can be considered a core tool. I think actually it makes plenty of sense to enhance pg_autovacuum while it's still contrib stuff. My guess is it'll be much less painful to whack it around in minor or major ways while it's standalone code. Once it's integrated in the backend, making significant changes will be harder and more ticklish. So, now is precisely the time to be experimenting to find out what works well and what features are needed. regards, tom lane