Re: locks within select

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: locks within select
Date: 2021-12-14 19:22:41
Message-ID: CADX_1aZoVVEfvZAT2jcPoMaWWXZ0v5nWieJ9=wnthnzE=1j3eA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excellent !
thanks a lot, it was exactly what I was looking for.

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Dec 14, 2021 at 6:14 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Tue, 2021-12-14 at 13:38 +0100, Marc Millas wrote:
> > but... when you do setup a streaming replication, there is, in
> postgresql.conf, a variable:
> > max_standby_streaming_delay = 30s # max delay before canceling queries
> when reading streaming WAL;
> >
> > as the secondary is, by nature, read only, I was wondering why it can be
> necessary to cancel a read request...
>
> Perhaps this can explain some of what is going on:
>
>
> https://www.cybertec-postgresql.com/en/streaming-replication-conflicts-in-postgresql/
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2021-12-14 19:30:55 Re: Why can't I have a "language sql" anonymous block?
Previous Message Peter Geoghegan 2021-12-14 19:21:54 Re: When Update balloons memory