Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DA2CF6344BC for ; Thu, 1 Oct 2009 11:42:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92773-03 for ; Thu, 1 Oct 2009 14:42:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128141.authsmtp.com (outmail128141.authsmtp.com [62.13.128.141]) by mail.postgresql.org (Postfix) with ESMTP id BF939633C5A for ; Thu, 1 Oct 2009 11:42:10 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n91Eg17Y086558; Thu, 1 Oct 2009 15:42:01 +0100 (BST) Received: from [192.168.0.5] (88-110-190-77.dynamic.dsl.as9105.com [88.110.190.77]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n91EfutW009480; Thu, 1 Oct 2009 15:41:57 +0100 (BST) Subject: Re: Hot Standby on git From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <4AC2FBB9.7060304@enterprisedb.com> References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4AC2FBB9.7060304@enterprisedb.com> Content-Type: text/plain Date: Thu, 01 Oct 2009 15:45:30 +0100 Message-Id: <1254408330.17864.233.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 91fabfc3-ae98-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaARbYlpF HGQLW11EUVh7XWJ/ bg0fZQ1DY0tOQQRj UFZORU1QEQdtHhxP WBcfJ083M2JGeHd0 bUYsXHdZXgpzdBAs EBgHFnBXMG5odWEe BBVFfgMHJB5Kfh1H bFR2U3sIYG1JBC9q VzwTFhsSEA9kHWx1 RR1FFk4bR0oBD3Y7 QVgNHClH X-Authentic-SMTP: 61633235383639.1014:706/Kp X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/45 X-Sequence-Number: 146857 On Wed, 2009-09-30 at 09:33 +0300, Heikki Linnakangas wrote: > Looking at the changes to StartupMultiXact, you're changing the locking > so that both MultiXactOffsetControlLock and MultiXactMemberControlLock > are acquire first before changing anything. Why? Looking at the other > functions in that file, all others that access both files are happy to > acquire one lock at a time, like StartupMultiXact does without the patch. I think those changes are just paranoia from early versions of patch. We now know for certain that MultiXact isn't used at the time StartupMultiXact() is called. The same isn't true for StartupClog() and StartupSubtrans() which need to cope with concurrent callers. Will remove changes and document that nothing touching it when it runs. -- Simon Riggs www.2ndQuadrant.com