| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Lucas <root(at)sud0(dot)nz> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.2 high replication lag |
| Date: | 2021-07-14 05:30:51 |
| Message-ID: | 0d5784f69c8f3b61523917b7ee5ea12a042bf478.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2021-07-13 at 20:14 -0700, David G. Johnston wrote:
> On Tue, Jul 13, 2021 at 8:01 PM Lucas <root(at)sud0(dot)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.
Perhaps you might find the following article interesting, where I tried to
discuss this topic in some depth:
https://www.cybertec-postgresql.com/en/streaming-replication-conflicts-in-postgresql/
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-07-14 05:32:52 | Re: Need to check each element of an array satisfies a foreign key constraint |
| Previous Message | David G. Johnston | 2021-07-14 03:14:11 | Re: PostgreSQL 9.2 high replication lag |