Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CD0AA63360E for ; Wed, 7 Oct 2009 10:02:13 -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 36705-01 for ; Wed, 7 Oct 2009 13:01:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136056.authsmtp.com (outmail136056.authsmtp.com [62.13.136.56]) by mail.postgresql.org (Postfix) with ESMTP id 187C76329B3 for ; Wed, 7 Oct 2009 10:01:56 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt7.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n97D1nOX085498; Wed, 7 Oct 2009 14:01:49 +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 n97D1icH004898; Wed, 7 Oct 2009 14:01:45 +0100 (BST) Subject: Re: Hot Standby on git From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <4AC5AC7A.8070801@enterprisedb.com> References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4AC37D2D.9060400@enterprisedb.com> <1254406060.17864.219.camel@ebony.2ndQuadrant> <4AC5AC7A.8070801@enterprisedb.com> Content-Type: text/plain Date: Wed, 07 Oct 2009 14:05:37 +0100 Message-Id: <1254920737.26302.227.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 90ebe088-b341-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAJbYlpF HGQLW11EUVl7WWJ/ bw8fZQ1DY0tOQQdp WFZLQVFNFgBqBAMB SEAXVW1zLlY+eH50 bU9qEHJeXEw0fEYo EBtUHWUbN2RkaX0e URQNagpUI1dXfh9H aFZ7XXQFZGQPKBg1 TUcAHxkaHhhlExEd YgYRZWkOSEAHFC90 QBZKEjQzdQAA X-Authentic-SMTP: 61633235383639.1014:706/Kp 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/435 X-Sequence-Number: 147247 On Fri, 2009-10-02 at 10:32 +0300, Heikki Linnakangas wrote: > Simon Riggs wrote: > > I will docuemnt the recommendation to set max_standby_delay = 0 if > > performing an archive recovery (and explain why). > > Hmm, not sure if that's such a good piece of advice either. It will mean > waiting for queries forever, which probably isn't what you want if > you're performing archive recovery. Or maybe it is? Maybe -1? I guess it > depends on the situation... I've changed that to -1 now, which was what I meant. 0 is likely to be a very wrong setting during archive recovery. -- Simon Riggs www.2ndQuadrant.com