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 8F416D1C9CF for ; Tue, 5 Aug 2003 14:29:43 +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 13284-07 for ; Tue, 5 Aug 2003 11:28:29 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id B93F8D1C9C8 for ; Tue, 5 Aug 2003 11:29:32 -0300 (ADT) Received: from dev6.int.libertyrms.com ([10.1.2.212] helo=libertyrms.info) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19k2oY-0007aT-00; Tue, 05 Aug 2003 10:29:26 -0400 Received: by libertyrms.info (Postfix, from userid 1079) id 470F9BBADC; Tue, 5 Aug 2003 10:29:26 -0400 (EDT) To: shridhar_daithankar@persistent.co.in Cc: pgsql-performance@postgresql.org, "Matthew T. O'Connor" Subject: Re: Some vacuum & tuning help From: Christopher Browne Date: Tue, 05 Aug 2003 10:29:26 -0400 Message-ID: <60el00jhyx.fsf@dev6.int.libertyrms.info> User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/63 X-Sequence-Number: 2880 Shridhar Daithankar wrote: > I agree, specifying per table thresholds would be good in autovacuum.. Which begs the question of what the future direction is for pg_autovacuum. There would be some merit to having pg_autovacuum throw in some tables in which to store persistent information, and at that point, it would make sense to add some flags to support the respective notions that: -> Some tables should _never_ be touched; -> Some tables might get "reset" to indicate that they should be considered as having been recently vacuumed, or perhaps that they badly need vacuuming; -> As you suggest, per-table thresholds; -> pg_autovacuum would know when tables were last vacuumed by it... -> You could record vacuum times to tell pg_autovacuum that you vacuumed something "behind its back." -> If the system queued up proposed vacuums by having a "queue" table, you could request that pg_autovacuum do a vacuum on a particular table at the next opportunity. All well and interesting stuff that could be worth implementing. But the usual talk has been about ultimately integrating the functionality into the backend, making it fairly futile to enhance pg_autovacuum terribly much. Unfortunately, the "integrate into the backend" thing has long seemed "just around the corner." I think we should either: a) Decide to enhance pg_autovacuum, or b) Not. In view of how long the "better answers" seem to be taking to emerge, I think it makes sense to add functionality to pg_autovacuum. -- output = reverse("ofni.smrytrebil" "@" "enworbbc") Christopher Browne (416) 646 3304 x124 (land)