public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fujii Masao <[email protected]>
To: Marko Tiikkaja <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: hot_standby_feedback and max_standby_archive_delay
Date: Mon, 3 Feb 2014 01:08:44 +0900
Message-ID: <CAHGQGwFnnw0sBYh6=osF7_A+uTyUC5=-56hrJv6jvYb=C4hhbQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

On Fri, Jan 17, 2014 at 8:38 AM, Marko Tiikkaja <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: hot_standby_feedback and max_standby_archive_delay
  In-Reply-To: <CAHGQGwFnnw0sBYh6=osF7_A+uTyUC5=-56hrJv6jvYb=C4hhbQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox