Does max_standby_streaming_delay delay all WAL commits?

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Does max_standby_streaming_delay delay all WAL commits?
Date: 2016-03-03 15:43:59
Message-ID: CAAcYxUeCD0jP8yR7SGmQWDAA2a29KJz_eCX1FvgR3bHZY6ONvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We're running into issues with canceled queries on a standby server and
have be debating between enabling hot_standby_feedback and setting
max_standby_streaming_delay to something large.

Using max_standby_streaming_delay seems to have the advantage of keeping
the master independent of the standby, but will a long running query mean
that all WAL commits are delayed? Or just those that affected by the long
running query?

Thanks,
Dave

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don O'Hara 2016-03-03 18:41:52 Changing schema name when restoring?
Previous Message bricklen 2016-03-03 02:59:09 Re: pg_dump limit 1000 rows