Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wT4Rp-000IFV-0L for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 21:08:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wT4Rl-004Slv-17 for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 21:08:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wT4Rl-004Sln-06 for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 21:08:49 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wT4Ri-00000000CjN-1jAC for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 21:08:48 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-7bf0b47d2f1so129151217b3.3 for ; Fri, 29 May 2026 14:08:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780088923; cv=none; d=google.com; s=arc-20240605; b=PN2gpf21QhIYDawTHgiQgkl/Q5RwNd66/8qG1AKtMXHCMq8p75ghueieqUB0+rxbZB vLw9VqXDZePiRXEL9Uu37r/vhuFBih3GhMesEloBAeG52hf6ibFHlVTHwEdwWsGZilpH T87HbAv2O8qJkKeWzKc2AGa+a4068AIDhUzfn2nAVl4iNqAZ6UHLqreNhiSRwmqu2f7T SUQd8PTivzpuSY89pwtdKdONKYUpzWfEDoyIwKGEOz1gRr3diGF3a4A5LGiNXRY1Igwt kYHx6hXUrYd7luD5fDkO6rn24DoWn9EUnHQ/atjVJRmH5clbKWKOXfm4acWBCgEaR7i2 TLlg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=ob1DSxPm/jw2Awy0abajRXER0V3CJmgzPYrK0s8EPnQ=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=C8BBHbL38pwk+4URJ4gF1lSt+Yl6qO5p1znNwWzwPclG/abY/GgDCPShhwjzSJjcTn gN7exptwFrDcclZ9BhO83tyi3XAKl2OhxShqlXAI5Vqca9ZVfw2rN9nIlKM1nWvF0szP /sZBJIC2/RdHPOMSz/wML1Y34xDorzbXVvmEgTwzPdWeO/H5UsLQoG4QJ05aqnuTeN7b VlMGcNuEzRr/H71z7ZNohx2GImudStDy9jADlYJhLPG6v1w1Ch0IQkw1rOaOwpTgSTCB fU7wnAgY1p1TR9NCGeCe0FCz/7f24AfZsEOHo6CW6phCHjQJ2fOc5Yb27RZKUQ6rPP3v D+dA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1780088923; x=1780693723; darn=lists.postgresql.org; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :from:to:cc:subject:date:message-id:reply-to; bh=ob1DSxPm/jw2Awy0abajRXER0V3CJmgzPYrK0s8EPnQ=; b=fztY+JAaOdoBsbqcIhhuo4rWUjiod+U4sgsLsLWyMLgGzIhcJ5oD6j5h3euR53FHNf dgN7rug8AQEFS7NK5Qx2sdsOSrItwkgY3kl8h1ZYVeMmv+P1E9rQWdqJhW3Gk6jc1/DB 6nxG6DBRhApwedlBB7UZi9hhin4TAAJbrL6js= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780088923; x=1780693723; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ob1DSxPm/jw2Awy0abajRXER0V3CJmgzPYrK0s8EPnQ=; b=NgNXr7T2FoX1XMMj4wyBBjtBYslJmjcNIc0hTPglmZf24bnJ9ZwJ9wa6gzYLCwECtO bOFLy1b9oLGqnTAqglI34c96FRWNpTFuchrkQro7d7Iy16YT2smmbC3syTOlgQSn+MM4 M22JxQ8cNY3J8Y5yCBh116R9ixbRW03/cCc/gPZ1uPNtqyJTg1OdHWbPhLoaK51gEgqw XEIUFbXvNNT1mN59VMsCfPXxfOULdiTxH+UAolbvP2Ia7tGCCnQFzH7SSkHo75ody29k LF9EyN5i+fZO++NNPgs6M6UAHHUNzKULzOfRDV0sqjZbTYwLlatMjTaLO3srgdb38c78 XdQw== X-Gm-Message-State: AOJu0Ywizl2aU9Oo13fEknbVB8hLGG+h5MrsvQBnUmcmdyDRyP9fJT+p tW1+4ba2VtZG9CcdSAdEOv+1tZ17Iq+/UOuBg8b1h/Nd0dWfDvzC4ahyiujmo8CZka5uanHG4rr uB86mz1w/C0xa+HC4i3LPBEZdzy1BkRiHaKLZz3JaqG0jc91S7r7fHanw/8fFMdzzyK+BclCDA+ q0A1/ZBkC/Yn5Mvmdc8jt/at3AToc7v7yAwYoYVmZdiJZp8/VUN1yNgyXFThDxMxsax1GNXsZ+s mpK5iJcwAF5Jd3yR0ZvXjkFwCa1qVLBZbnPCIxLOSCyNUccGZqr5g0L1/gj5emXq93S4mv8ntu9 NA== X-Gm-Gg: Acq92OGusjmdzw/T7CMDLMg6Ol7shWCEIgpr/DWnWPd1WsRowH372fUhiffGlkDmlUd EaJu2ACb7/MdewzX99F1Xjl6ZBjWTI2xrfbeBdNPKXF4vminA9IyNEb0zN9C2wki2DXR/MkqCYM hwMPSWP7BsehsEnTbrxJIQ5FfJW6BAkkfxOZwXQacAKj/2QNDHkyyiDndsIKVMzEShmvFeHrOVa V1yFPCxttEMAJaTU/8Eg9IX/0RArFVTxnkMo9qD0zi/uQcyNdEfRV1OmukzCefVJUhRXN5edSA+ exlJpmZG8uDE0eP0P4YMENLLpi+9zB1VaJ0XJHgs9U99P9BAqPJcMtX6Ez+usjauQSuvpjEarBj wjH0= X-Received: by 2002:a05:690c:4b02:b0:7bd:8cd8:de2e with SMTP id 00721157ae682-7e05ed31837mr11809587b3.46.1780088923165; Fri, 29 May 2026 14:08:43 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Fri, 29 May 2026 16:08:42 -0500 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Fri, 29 May 2026 16:08:42 -0500 From: Zsolt Parragi In-Reply-To: References: MIME-Version: 1.0 Date: Fri, 29 May 2026 16:08:42 -0500 X-Gm-Features: AVHnY4JhwyM5d38D3zoCoM36r7thEuJ3BsByUHw0TXOz38bM-ECWjFvpZec97nw Message-ID: Subject: Re: [PATCH] Prevent repeated deadlock-check signals in standby buffer pin waits To: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello! Shouldn't this need a condition similar to ResolveRecoveryConflictWithLock (if (logging_conflict) ...)? Otherwise this can result in a long wait time, with: log_recovery_conflict_waits = on deadlock_timeout = 100ms max_standby_streaming_delay = 5s It can wait for 5 seconds instead of the current 0.1 seconds without the change.