Re: hot_standby_feedback and max_standby_archive_delay

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: hot_standby_feedback and max_standby_archive_delay
Date: 2014-02-02 16:08:44
Message-ID: CAHGQGwFnnw0sBYh6=osF7_A+uTyUC5=-56hrJv6jvYb=C4hhbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Fri, Jan 17, 2014 at 8:38 AM, Marko Tiikkaja <marko(at)joh(dot)to> 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Robert Haas 2014-02-03 15:49:30 pgsql: Document a few more regression test hazards.
Previous Message Fujii Masao 2014-02-01 09:49:50 category of min_recovery_apply_delay