Re: Long running query causing XID limit breach

From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: sud <suds1434(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Long running query causing XID limit breach
Date: 2024-05-26 08:13:28
Message-ID: CAKkG4_nLNSDSDd7emC+p4rEicmeCBCBJozzy3QRFvO7BWh3SRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, May 25, 2024 at 11:00 PM sud <suds1434(at)gmail(dot)com> wrote:

>
> But i have one question here , does max_standby_streaming_delay = 14 ,
> means the queries on the standby will get cancelled after 14 seconds?
>

No, your query gets cancelled when it stalls replication for >14 sec. If
your master is idle and does not send any WAL and the replica has
caught up, the query can take as long as it wants.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sud 2024-05-26 09:15:50 Re: Long running query causing XID limit breach
Previous Message David HJ 2024-05-26 05:56:16 Re: Long running query causing XID limit breach