Does max_standby_streaming_delay delay all WAL commits? - Mailing list pgsql-admin

From Dave Johansen
Subject Does max_standby_streaming_delay delay all WAL commits?
Date
Msg-id CAAcYxUeCD0jP8yR7SGmQWDAA2a29KJz_eCX1FvgR3bHZY6ONvA@mail.gmail.com
Whole thread Raw
Responses Re: Does max_standby_streaming_delay delay all WAL commits?  (Venkata Balaji N <nag1010@gmail.com>)
List 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

pgsql-admin by date:

Previous
From: bricklen
Date:
Subject: Re: pg_dump limit 1000 rows
Next
From: "Don O'Hara"
Date:
Subject: Changing schema name when restoring?