Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 9.2 high replication lag - Mailing list pgsql-general

From David G. Johnston
Subject Re: PostgreSQL 9.2 high replication lag
Date
Msg-id CAKFQuwayvL=PLFu=UxV5pBakJfiwLyqp33_cSc+VNb2UOS_q1w@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.2 high replication lag  (Lucas <root@sud0.nz>)
Responses Re: PostgreSQL 9.2 high replication lag  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
On Tue, Jul 13, 2021 at 8:01 PM Lucas <root@sud0.nz> wrote:
According to the documentation, max_standby_streaming_delay is a configuration parameter determining how long a standby server should wait before canceling queries that conflict with pending WAL entries received via streaming replication.

My question then is: Which queries, if the slave can only receive SELECTs?

The select queries...

Follow the link in the docs for max_stanbdy_steaming_delay to:

https://www.postgresql.org/docs/current/hot-standby.html#HOT-STANDBY-CONFLICT

for the details.

David J.

pgsql-general by date:

Previous
From: Lucas
Date:
Subject: Re: PostgreSQL 9.2 high replication lag
Next
From: Laurenz Albe
Date:
Subject: Re: PostgreSQL 9.2 high replication lag