Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9zbG-0005iO-HC for pgsql-docs@arkaria.postgresql.org; Sun, 02 Feb 2014 16:08:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W9zbF-0006u4-Pw for pgsql-docs@arkaria.postgresql.org; Sun, 02 Feb 2014 16:08:49 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9zbF-0006ty-4q for pgsql-docs@postgresql.org; Sun, 02 Feb 2014 16:08:49 +0000 Received: from mail-pa0-x230.google.com ([2607:f8b0:400e:c03::230]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9zbC-0001dC-IS for pgsql-docs@postgresql.org; Sun, 02 Feb 2014 16:08:48 +0000 Received: by mail-pa0-f48.google.com with SMTP id kx10so6181162pab.7 for ; Sun, 02 Feb 2014 08:08:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=2FHSjTgB+nnE/hu8TUmMKr5is1d2rUcxSE+f9MwQ7OM=; b=EFaBG3omhzU1TGCbX4iIfedhsJAoVY3ROoAiab2xtQsg201Zdo2rAD/+gvt6UmOqAo 5IbWfJ0YXoEBQfSe1/XNrEdpR4Kf8oOnNP1Zfbw/OyMSmBgcUhyGarYiINXIDAB1FptL MIkaU0H7kV0XHgAnu0/orFaKoo8IbukKroH+LMGll1gkLQgK2ZcBQnvQr+3x/OddVkJv +mB4SJaAACh2ay2Qn2cdqWT8Za9Nbc9/K9+bP0rmLInKRyq3I1x83OS3QYmBuxZPv/Hl ustZlxszHSw/kuKYCq9avotVAE36G4U7kMsfEtUNWYqYesEYcobh47EipWLiAD+JdAdd C3hg== MIME-Version: 1.0 X-Received: by 10.66.145.199 with SMTP id sw7mr2224425pab.143.1391357324592; Sun, 02 Feb 2014 08:08:44 -0800 (PST) Received: by 10.70.87.202 with HTTP; Sun, 2 Feb 2014 08:08:44 -0800 (PST) In-Reply-To: <52D86D65.5010000@joh.to> References: <52D86D65.5010000@joh.to> Date: Mon, 3 Feb 2014 01:08:44 +0900 Message-ID: Subject: Re: hot_standby_feedback and max_standby_archive_delay From: Fujii Masao To: Marko Tiikkaja Cc: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -0.6 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Fri, Jan 17, 2014 at 8:38 AM, Marko Tiikkaja wrote: > Hi, > > Myself and others found this statement in the documentation about $SUBJECT > very confusing: "max_standby_archive_delay must be kept large in this case, > because delayed WAL files might already contain entries that conflict with > the desired standby queries.". After a chat with Andres I've tried to make > it clearer what said statement tries to convey. > > Did I succeed? Don't we need to increase also max_standby_streaming_delay in the case that you mentioned in the patch? When the standby successfully reconnects to the master, lots of WAL files would be streamed and they might already have WAL entries that conflict with standby queries. No? Regards, -- Fujii Masao -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs