X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 07EE6D1D809 for ; Sat, 22 Nov 2003 00:52:02 +0000 (GMT) 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 10327-08 for ; Fri, 21 Nov 2003 20:51:36 -0400 (AST) Received: from smtp.istop.com (dci.doncaster.on.ca [66.11.168.194]) by svr1.postgresql.org (Postfix) with ESMTP id E2D6ED1D7C5 for ; Fri, 21 Nov 2003 20:51:32 -0400 (AST) Received: from stark.dyndns.tv (gsstark.mtl.istop.com [66.11.160.162]) by smtp.istop.com (Postfix) with ESMTP id C055336E06; Fri, 21 Nov 2003 19:51:17 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 1ANLzZ-0006LP-00; Fri, 21 Nov 2003 19:51:17 -0500 To: pgsql-hackers@postgresql.org Subject: Re: [PERFORM] More detail on settings for pgavd? References: <200311181558.45847.josh@agliodbs.com> <200311210909.00978.josh@agliodbs.com> <3FBE8289.1040009@zeut.net> <200311211323.19003.josh@agliodbs.com> <15608.1069455896@sss.pgh.pa.us> In-Reply-To: <15608.1069455896@sss.pgh.pa.us> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 21 Nov 2003 19:51:17 -0500 Message-ID: <877k1t2pkq.fsf@stark.dyndns.tv> Lines: 17 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1213 X-Sequence-Number: 47501 Tom Lane writes: > Josh Berkus writes: > > BTW, do we have any provisions to avoid overlapping vacuums? That is, to > > prevent a second vacuum on a table if an earlier one is still running? > > Yes, VACUUM takes a lock that prevents another VACUUM on the same table. The second vacuum waits for the lock to become available. If the situation got really bad there could end up being a growing queue of vacuums waiting. I'm not sure how likely this is as the subsequent vacuums appear to finish quite quickly though. But then the largest table I have to play with fits entirely in memory. -- greg