Re: Changes to recovery_min_apply_delay are ignored while waiting for delay - Mailing list pgsql-hackers

From Soumyadeep Chakraborty
Subject Re: Changes to recovery_min_apply_delay are ignored while waiting for delay
Date
Msg-id CAE-ML+9MUbZ7t6picoOQHn2ihAoZmSUPHmFvbcBurcuky_3HjA@mail.gmail.com
Whole thread Raw
In response to Re: Changes to recovery_min_apply_delay are ignored while waiting for delay  (Soumyadeep Chakraborty <soumyadeep2007@gmail.com>)
Responses Re: Changes to recovery_min_apply_delay are ignored while waiting for delay  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Rebased. Also added a stronger check to see if the standby is stuck in
recovery_min_apply_delay:

$node_standby->poll_query_until('postgres', qq{
SELECT wait_event = 'RecoveryApplyDelay' FROM pg_stat_activity
WHERE backend_type='startup';
}) or die "Timed out checking if startup is in recovery_min_apply_delay";

Attached v3.

Regards,
Soumyadeep (VMware)

Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Next
From: Tomas Vondra
Date:
Subject: Re: Use generation context to speed up tuplesorts