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 1wcTK3-003NGc-1P for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2026 19:31:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcTK1-002AxJ-2g for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2026 19:31:41 +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 1wcTK1-002AxA-1R for pgsql-hackers@lists.postgresql.org; Wed, 24 Jun 2026 19:31:41 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wcTJw-000000005D8-2Vrs for pgsql-hackers@lists.postgresql.org; Wed, 24 Jun 2026 19:31:40 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-7fdb04d774aso20524637b3.2 for ; Wed, 24 Jun 2026 12:31:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782329494; cv=none; d=google.com; s=arc-20240605; b=MP/wtrt2l8LzgQBSjm96o/6Wd1tpVoLcC/etsW1it/W+Nz0j331Ln36tavdQBH/NIp E1CndVEUpDsR/4Flr2e4VULl8EE4qvSGcpHnhMKxQYlo4bR4rJLbGoDyQm/f5GJol1Pj bvLGBCSxg5fTHqF5mU8A8jTWBGFZ+6I4cGZNHCNTWIee90qyXeBN9xT6EENEKSuardON EuBQf8DHN2EqxxrvyNnfSYayOe7Yx3kyDf1Z80a58NLBlXuJIiwwjzYhfSGDhraCtlE2 LyzsJuVRrd6uloAzyOfquiqoakbrcQTEbLR3oF9C+x7ZBO2xfxBzMMnr6QuAQefJHE82 8Wtg== 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=ISWGqibjhhgpAEaVy+6OrpvnyMFuVkcmY3bxt3neUxE=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=VJtq6zs5ILKM5+vh0QfUxrtHivg9LgHc3bbX9h0psQ1p8f04XIKFTNPFGSgfnC7iq7 eVKyAFMTItzvy7jLdqD4nWTIH4Vc4XIjSJjK4mES8SSpSgMAmKx8iTQbvuW5ERWyJqjX dBq8LKUECZ9eh8TzzVK+yWjmIcurd862QJ5z3lqj0gdY4gqOrbTQFc1EY9sS3TwvT4YF 5g/cn0ekQgw8PXrP4BP0chwQMxpfCn3VCCNud/rb3SY/8Pt6VLNKFM6d4vJtGNVpTTYY 5mNrJ1BBbaM1ds4F1+HT458LHgY3BCFlpS0RhkpOXdz4v4QE6GXraDIxdBS9X9aU+dZO 7ilg==; 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=1782329494; x=1782934294; 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=ISWGqibjhhgpAEaVy+6OrpvnyMFuVkcmY3bxt3neUxE=; b=WMagE8oZXGMjHm8f5S+tnQ64G2kv1LR5Vw7WP06Is/Zh37Owijpw79MYgsBwzi5P5h qS+f+jOxjotdDa57Kh0wdLgenXI6iH9eYAOB5cGu3rdz/3fOCDct+VpqE03X5fSCSjXA hTXB4jNRvTZah6biCmUSmEJPWBYuPtJBjnWsGdULoS08OckxOJZOXh13KLd9G/UT0CFW JBaAB4foLSig7SN2VUNh/KJ3rksgH3CYROabGNI52YYjJ+ST1jvXMWp+pt2gKDNLujal GGZZBX5wPG7VkQW9JbJziiFldgqb1vE2jcJ5lKYuiy0IDGQ5yJr38J87coRnLABEikFQ Ny0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782329494; x=1782934294; 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=ISWGqibjhhgpAEaVy+6OrpvnyMFuVkcmY3bxt3neUxE=; b=jbu1Ww8r3Vk/yvnsiwsio1eplJUrnEDJUQIWX3EpRs2ILCB+5APT11O9EJ9ujOHuZX 0RC5E2THB992UFaGK9o/mGdr/TWL4qkvrKTkgfRNjhgFQkfdxeqQnCYoecSUHmFruBqD wxDuMN5KGsSuedfksi4Mw4n1Cmy+dZlRFRgpSY/6gu+3vF5VNZwaPGqQNpejHc3wRb+u uS6bbJfInowZsgM9ic/hPhHwVEJkIxazychqfi2QZSdo1FjRAUzJw3dV6o4vYjPl/nyE yqmu6ntdbaLNgqyqAThPoQASXEUbFh8qBMdWcWVtXp1VQqa0sjFteRighgn4VGkSa1+e tZbw== X-Gm-Message-State: AOJu0YxqMI0NsiR9pnSyKBi41gYN6gKRTTEjcfg23Z+rHC1wwramGN4n Pp/N98SxYATJUeVAQQtOXcPQ/Z+4m6b0EHcRnxXXatYHk5ueewnC+h30ovl7wVll5xWFt/4KfNu SjEdTa+JjC96sFo7/gBmHRc4s1p5sXs20ummvUT+DsuZ/uYa6c/J342iZeHQZ090aIlcl6MCHld 76GkifjXg96uRV68uEEj4usCiOkD54V6SB057pnbl5KUzGvpUxthkZujwSO8tDMn31/BoevgEV3 FbaB5s1EpvsqwW0tyTq66NZLICI92PAAG1qmtvNd1Zo7bErj26TVeP+bhXX60A3a6atgoZv1u42 dQ== X-Gm-Gg: AfdE7clHoM+6qnLHQ5FMqLYmLPasTA8+HPqkmIUv6iltn4N2xzgjjL0ziKrBR31qzx3 Dka+I2vCXgifsnEu7Lv0NAj9hEL7iIT0ZFlKmlDktXQ1epPzhhyN3chu1mSF6RDIrUzmGCbRtrz AWmgFyc9XyZYnbbu65159xgqVXnpAZ5DMmOvu3SPcidwxpE0hAGD2ZPbVxwBbZBiC0P1LP5oE2h LIP+ybaX2rG7nNWiiDwNIpZz543mYc+JW51IY+UPpUZ5VG3cIe3VpxSplPNu0/vlGOgt8KU5d+Q /s/+1g3ueLJprUwoYTiZ1sU/zJenok3uStmDfG6Sig9Wd9lcSVspms047A== X-Received: by 2002:a05:690c:3605:b0:7dd:1e9c:96af with SMTP id 00721157ae682-8026616311dmr228549957b3.30.1782329494077; Wed, 24 Jun 2026 12:31:34 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 24 Jun 2026 12:31:33 -0700 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 24 Jun 2026 12:31:33 -0700 From: Zsolt Parragi In-Reply-To: References: MIME-Version: 1.0 Date: Wed, 24 Jun 2026 12:31:33 -0700 X-Gm-Features: AVVi8Ce5jqcjXLOc1MdEWEDzt6J0UYj6xgxDJYJUZAdkAxHP1iI7hIuWD778g0w Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication 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 +my $locker = $node_sub->background_psql('postgres'); +$locker->query_until(qr/locker_ready/, qq{ + \\echo locker_ready + BEGIN; + TRUNCATE $clt; +}); This seems unstable to me: can't query_until return as soon as "locker_ready" appears in the output, before the begin; truncate?