X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57185D1B170 for ; Sat, 17 Jul 2004 21:06:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23169-07 for ; Sun, 18 Jul 2004 00:06:54 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 56EDFD1B1BE for ; Sat, 17 Jul 2004 21:06:50 -0300 (ADT) Received: from ool-4352919e.dyn.optonline.net ([67.82.145.158] helo=[192.168.1.10]) by outbound.mailhop.org with asmtp (Exim 4.20) id 1BlzCf-00003a-Ok for pgsql-hackers@postgresql.org; Sat, 17 Jul 2004 20:06:53 -0400 Subject: Vacuum Cost Documentation? From: "Matthew T. O'Connor" To: "pgsql-hackers@postgresql.org" Content-Type: text/plain Message-Id: <1090109213.4788.3.camel@zedora2> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Sat, 17 Jul 2004 20:06:53 -0400 Content-Transfer-Encoding: 7bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 67.82.145.158 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: Zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200407/924 X-Sequence-Number: 56485 Related to autovacuum work, I was looking into the new vacuum delay functionality. I might be missing something, but I can't find anything on it in the developer docs. Is that right? Also, in the default postgresql.conf there is: #vacuum_cost_naptime = 50 # 0-1000 milliseconds however psql reports this value as 0. I assume this is just postgresql.conf is just wrong. Can we fix this so it's consistent? Thanks, Matthew O'Connor