Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 926F063360F for ; Wed, 20 Jan 2010 14:45:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67799-04 for ; Wed, 20 Jan 2010 18:45:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136128.authsmtp.com (outmail136128.authsmtp.com [62.13.136.128]) by mail.postgresql.org (Postfix) with ESMTP id B30ED63290E for ; Wed, 20 Jan 2010 14:45:18 -0400 (AST) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o0KIjAK6016201; Wed, 20 Jan 2010 18:45:10 GMT Received: from [192.168.0.3] (88-110-172-79.dynamic.dsl.as9105.com [88.110.172.79]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o0KIj8EN048865; Wed, 20 Jan 2010 18:45:08 GMT Subject: Re: Synchronization primitives (Was: Re: An example of bugs for Hot Standby) From: Simon Riggs To: Heikki Linnakangas Cc: Andres Freund , Tom Lane , pgsql-hackers@postgresql.org, Hiroyuki Yamada In-Reply-To: <4B5744C1.40806@enterprisedb.com> References: <200912151111.AA00168@silver.kokolink.net> <201001201740.22069.andres@anarazel.de> <14578.1264006776@sss.pgh.pa.us> <201001201841.15760.andres@anarazel.de> <4B5744C1.40806@enterprisedb.com> Content-Type: text/plain Date: Wed, 20 Jan 2010 18:45:07 +0000 Message-Id: <1264013107.4043.3961.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: eeec65c0-05f3-11df-80b9-0022640b883e X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFagVbZ1hf HGQLWlREUVV7XWZ/ awIfZQ1DY0tOQQRt UlZOS01XHAJ3AVJe BmVnCBEHCQVCcHZ2 YAhkVnhbEhEvIBV7 Rx1UCG0DM2R9aWFL Bl1Qd1FdbQNKfB1D blAtXHsONCtlM3Bw JB41NDArOjNeOi1J QwYLZUoIQEMKAj8i SgtKXQomBh9NfShh Zy8GA3U/MXwqBw0b NxMsSVsdKxsfQgpQ fQlHHSBCb1cGXWIL Ch8SZlIXFjFXUGY0 X-Authentic-SMTP: 61633235383639.1015:706/Kp X-AuthFastPath: 255 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.41 tagged_above=-10 required=5 tests=AWL=0.189, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201001/1999 X-Sequence-Number: 155220 On Wed, 2010-01-20 at 20:00 +0200, Heikki Linnakangas wrote: > Hot standby also has a polling loop where it waits for a > transaction a transaction to die, though I'm not sure if that can be > fit into the same model I prefer that in the context of HS because the Startup process is waiting for things to die. Given that their death may not be handled sweetly, I would not wish to rely on that to wake Startup. In the other two cases you mention all processes are working together normally and we aren't expecting the other processes to die. -- Simon Riggs www.2ndQuadrant.com