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 4B217D1B91B; Fri, 23 Apr 2004 14:14:00 -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 92426-10; Fri, 23 Apr 2004 14:13:59 -0300 (ADT) Received: from area51.givex.com (spider.givex.com [209.205.24.147]) by svr1.postgresql.org (Postfix) with ESMTP id 31FB1D1B470; Fri, 23 Apr 2004 14:13:57 -0300 (ADT) Received: by area51.givex.com (Postfix, from userid 66) id 5A2D11924E; Fri, 23 Apr 2004 13:13:50 -0400 (EDT) Received: from imp.druid.net (imp.givex.com [192.168.7.111]) by area51.givex.com (Postfix) with SMTP id 28DD6191E1; Fri, 23 Apr 2004 13:13:49 -0400 (EDT) Date: Fri, 23 Apr 2004 13:13:54 -0400 From: "D'Arcy J.M. Cain" To: Bruce Momjian Cc: pg@fastcrypt.com, matthew@zeut.net, coelho@cri.ensmp.fr, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org Subject: Re: [HACKERS] What can we learn from MySQL? Message-Id: <20040423131354.30f126da.darcy@druid.net> In-Reply-To: <200404231708.i3NH8UM19188@candle.pha.pa.us> References: <20040423124716.521420c2.darcy@druid.net> <200404231708.i3NH8UM19188@candle.pha.pa.us> 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/225 X-Sequence-Number: 4197 On Fri, 23 Apr 2004 13:08:30 -0400 (EDT) Bruce Momjian wrote: > D'Arcy J.M. Cain wrote: > > 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. > > Or the number of connected backends, or both? I am sure that there are lots of ways to guage. Not sure which is best but I am sure that the smart people here will figure it out. The important thing, I think, is to let the engine make the decision dynamically. Personally I don't have a "quiet time" per se but there are random quiet periods. Something that jumps into the fray at those points would be really nicwe. -- 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.