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 E1C96D1B893; Fri, 23 Apr 2004 13:47:25 -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 88892-03; Fri, 23 Apr 2004 13:47:23 -0300 (ADT) Received: from area51.givex.com (unknown [209.205.24.147]) by svr1.postgresql.org (Postfix) with ESMTP id 12C62D1C4EC; Fri, 23 Apr 2004 13:47:22 -0300 (ADT) Received: by area51.givex.com (Postfix, from userid 66) id 60F6A19258; Fri, 23 Apr 2004 12:47:12 -0400 (EDT) Received: from imp.druid.net (imp.givex.com [192.168.7.111]) by area51.givex.com (Postfix) with SMTP id 5DF34191E4; Fri, 23 Apr 2004 12:47:10 -0400 (EDT) Date: Fri, 23 Apr 2004 12:47:16 -0400 From: "D'Arcy J.M. Cain" To: pg@fastcrypt.com Cc: matthew@zeut.net, coelho@cri.ensmp.fr, pgman@candle.pha.pa.us, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org Subject: Re: [HACKERS] What can we learn from MySQL? Message-Id: <20040423124716.521420c2.darcy@druid.net> In-Reply-To: <1082732840.13948.45.camel@localhost.localdomain> References: <200404230409.i3N49jC02890@candle.pha.pa.us> <58232.192.154.91.225.1082725121.squirrel@192.154.91.225> <1082732840.13948.45.camel@localhost.localdomain> X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386--netbsdelf) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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/221 X-Sequence-Number: 4193 On Fri, 23 Apr 2004 11:07:20 -0400 Dave Cramer wrote: > Does the current implementation of pg_autovacuum have a way of setting > windows where it is allowed to vacuum? Many large 24/7 will only allow > vacuumming at certain times of the day. It seems to me that the point of pg_autovacuum would be to run 24/7 so that there is never big hit on the system. Perhaps it could be designed to throttle itself based on current system usage though. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.