Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0962D6326A9 for ; Mon, 5 Oct 2009 08:47:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 55831-05 for ; Mon, 5 Oct 2009 11:47:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128147.authsmtp.com (outmail128147.authsmtp.com [62.13.128.147]) by mail.postgresql.org (Postfix) with ESMTP id 471BE6324D1 for ; Mon, 5 Oct 2009 08:47:15 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt5.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n95BlBAn026511; Mon, 5 Oct 2009 12:47:11 +0100 (BST) Received: from [192.168.0.5] (88-110-238-233.dynamic.dsl.as9105.com [88.110.238.233]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n95Bl7h1083096; Mon, 5 Oct 2009 12:47:07 +0100 (BST) Subject: Re: Hot Standby on git From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <4ABF4522.6060601@enterprisedb.com> References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4ABF4522.6060601@enterprisedb.com> Content-Type: text/plain Date: Mon, 05 Oct 2009 12:50:55 +0100 Message-Id: <1254743455.4691.153.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: cf710c32-b1a4-11de-9488-0022640b883e X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaABbYlpF HGQLW11EUV97XWR/ awIfZQ1DY0tOQQdp WFZLQVFNFgBqBAMB SEAXV2sucF1HeHZz ZU9kEHJTXUI0JhB6 Q04HFm8bN2YxbH0e URQNagpQeAtXfh9H aFZ7VCEFaWZSKBg1 TUcAHxkaHhhlExEd YgYRZWkOSEAHFC90 QBZKEjQzdQAA X-Authentic-SMTP: 61633235383639.1015: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.578 tagged_above=-10 required=5 tests=AWL=0.021, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/313 X-Sequence-Number: 147125 On Sun, 2009-09-27 at 13:57 +0300, Heikki Linnakangas wrote: > Per Simon's request, for the benefit of the archive, here's all the > changes I've done on the patch since he posted the initial version for > review for this commitfest as incremental patches. This is extracted > from my git repository at > git://git.postgresql.org/git/users/heikki/postgres.git. I'm working my way through these changes now. 1, 2, 15 and 16 applied. We discussed briefly your change 0011-Replace-per-proc-counters-of-loggable-locks-with-per.patch. I don't see how that helps at all. The objective of lock counters was to know if we can skip acquiring an LWlock on all lock partitions. This change keeps the lock counters yet acquires the locks we were trying to avoid. This change needs some justification since it is not a bug fix. -- Simon Riggs www.2ndQuadrant.com