Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 50FBA634DBB for ; Fri, 2 Oct 2009 04:51:53 -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 21902-01 for ; Fri, 2 Oct 2009 07:51:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136086.authsmtp.com (outmail136086.authsmtp.com [62.13.136.86]) by mail.postgresql.org (Postfix) with ESMTP id 15326632D6A for ; Fri, 2 Oct 2009 04:51:44 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n927pe3e078228; Fri, 2 Oct 2009 08:51:40 +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 n927pbE2025944; Fri, 2 Oct 2009 08:51:38 +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: Fri, 02 Oct 2009 08:55:14 +0100 Message-Id: <1254470114.17864.305.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 6a3833fc-af28-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAdbYlpF HGQLW11EUFV7XGJ/ aAIfZQ1DY0tOQQRj UFZORU1QEQdtHhxP WBccVVkgAgdGent5 YUIsXHdTWAp8JEV1 QU0CRnBXM2VodWEe BBVFfgMHJB5Kfh1H bFR2U3sIYG1JBC9q VzwTFhsSEA9kHWx1 RR1FFk4bR0oBD3Y7 QVgNHClH 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/141 X-Sequence-Number: 146953 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... That assumes that the purpose of the archive recovery is more important than running queries. As you say, it would mean always waiting. But the beauty is that you *can* run queries to determine when to stop, so having them cancelled defeats that purpose. -- Simon Riggs www.2ndQuadrant.com