X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 564815281F for ; Mon, 11 Jul 2005 10:29:00 -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 46965-05 for ; Mon, 11 Jul 2005 13:28:54 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1EBF352809 for ; Mon, 11 Jul 2005 10:28:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6BDSqq1007753; Mon, 11 Jul 2005 09:28:52 -0400 (EDT) To: Simon Riggs Cc: Ian Westmacott , pgsql-performance@postgresql.org Subject: Re: cost-based vacuum In-reply-to: <1121081504.3970.53.camel@localhost.localdomain> References: <1120839902.20657.197.camel@spectre.intellivid.com> <1121081504.3970.53.camel@localhost.localdomain> Comments: In-reply-to Simon Riggs message dated "Mon, 11 Jul 2005 12:31:44 +0100" Date: Mon, 11 Jul 2005 09:28:52 -0400 Message-ID: <7752.1121088532@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/106 X-Sequence-Number: 13347 Simon Riggs writes: >> I don't understand why this would be. I don't think there >> are any lock issues, and I don't see any obvious I/O issues. > The ANALYZE commands hold read locks on the tables you wish to write to. Unless there were more commands that Ian didn't show us, he's not taking any locks that would conflict with ANALYZE. So I don't believe this is the explanation. regards, tom lane