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 271CBD1B50D for ; Mon, 6 Oct 2003 02:01:50 +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 45524-04 for ; Sun, 5 Oct 2003 23:01:03 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id E4141D1B4ED for ; Sun, 5 Oct 2003 23:00:59 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1A6KgK-0008PS-00 for ; Sun, 05 Oct 2003 22:01:04 -0400 Received: by dba2 (Postfix, from userid 1019) id EB3ECC9FE; Sun, 5 Oct 2003 22:01:03 -0400 (EDT) Date: Sun, 5 Oct 2003 22:01:03 -0400 From: Andrew Sullivan To: PostgreSQL Performance Subject: Re: reindex/vacuum locking/performance? Message-ID: <20031006020103.GD3441@libertyrms.info> Mail-Followup-To: Andrew Sullivan , PostgreSQL Performance References: <60d6de9fah.fsf@dev6.int.libertyrms.info> <20031004152241.GL580@libertyrms.info> <1065396767.466.12.camel@tokyo> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1065396767.466.12.camel@tokyo> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/166 X-Sequence-Number: 3914 On Sun, Oct 05, 2003 at 07:32:47PM -0400, Neil Conway wrote: > been pointed out numerous times on -hackers and in the literature, using > LRU for a DBMS shared buffer cache is far from optimal, and better > algorithms have been proposed (e.g. LRU-K, ARC). We could even have the > VACUUM command inform the bufmgr that the pages it is in the process of > reading in are part of a seqscan, and so are unlikely to be needed in > the immediate future. Hey, when that happens, you'll find me first in line to praise the implementor; but until then, it's important that people not get the idea that vacuum is free. It is _way_ imporved, and on moderately loaded boxes, it'salmost unnoticable. But under heavy load, you need to be _real_ careful about calling vacuum. I think one of the biggest needs in the AVD is some sort of intelligence about current load on the postmaster, but I haven't the foggiest idea how to give it such intelligence. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110