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 1waYTK-001t1V-2G for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 12:37:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waYTJ-00G6hv-1s for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 12:37:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1waYTJ-00G6hn-0W for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 12:37:21 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1waYTH-000000018hk-0ung for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 12:37:20 +0000 Received: by mail-pj1-x1035.google.com with SMTP id 98e67ed59e1d1-36babe2c4bdso1173488a91.1 for ; Fri, 19 Jun 2026 05:37:18 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781872638; cv=none; d=google.com; s=arc-20240605; b=GbJ3rAb832KHHISVFFxg8Hf7vitLkMfXANCPTJsXY78bYMnnAg9zHujomYyF9WLEhz z3baWuJIx6gAjFBfzISW4b8BjM5YybprffHLvus5l9LnDlg4f3s3bBQGQDJBYcHAriFe otGWUBxQ093z5xfl/8XFvPvlYAwAmfXEmUZfKAZ06ptBhLUnBEXTRkuQLZulZmv8ZMd5 gdhyxDv1UMrMWo+YArbHmOPW7PcX421j4BQW1zKmVEDxkanjIekitffsmUzRMQ/MfoSR 0/YhjbbKKkWkyrFcnflaqWQ8qzsa5MxNZuTGtxnEAY+OXFsi0/tZaqhN6YU4sjnpCBlj G1xQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=VvkhCNJ+2OjEkag7xkYnlFZJzjGdOE+td28MtjZGit8=; fh=9f4LH98AM/s1MHZHVzwf73fpwESiWaJtdlIYPWVepHo=; b=DS4NAhaYMBqHkoEwznP0baL38a37WWCdXPQhP663Cd7ZotM13NkekNM5DSBZOGL+d9 QI8EVPVDiAFRkyzRdEizKXRR01Z3FeBYyZ399uXL69v8SjbLunCpvbWcS6EaR22Qdj3l HiaGVRRBiLOykw+JrcTr+UY6ID5xSgqSMPqSvJVAUZYMVdwUgoDNQgMAvMrCe+2Tsqo9 WcB9G9TBbZawNshCTHrU8e2yL9DaqidhOFwyna0kUwOGklt+2J0QTE0yreiDx8+tRDKz J5iGiAU4HQOy2IZV+vXQZn4cNDXd6o0GUHpJNnVA4Gq3QhX/VYUujFQqIWE7YRcjDPuC bdeQ==; 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=gmail.com; s=20251104; t=1781872638; x=1782477438; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=VvkhCNJ+2OjEkag7xkYnlFZJzjGdOE+td28MtjZGit8=; b=m+XAbh55sXxTkz2sQPPOqkzFQZSJaJvcxbK4BAAVTVNpTJFm0fsIlqwxmV868aKopr JDuCmVs4ypBkDNLZQGu6i1l8dbsXJeH/K3q0Lk5R+OX6Az/UKXFlQfQfiNPK/4x8lOuH DkCmdfiXnaGWMkfLw53rDI182gj1NzQPH4jqvfDJlTgzM//410HNrIJspJFPSX498rIh ZsX89NKhY3yECYfdMt+Kq6WxUUchWl01TbzPRwDglA/lfrF9GK/s+KtosUzxzN85qUPI VoIgo9KjRO/XDFB/TLtmu8ckDuRsLczGm0TTDbCPrc6UtGIVkvfbmlcDxnyFsBZ5DHlQ kjmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781872638; x=1782477438; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=VvkhCNJ+2OjEkag7xkYnlFZJzjGdOE+td28MtjZGit8=; b=pAZPOu/ZAjjyh4eki8WzF1Acz2pp/D0PrAMes6VugSuN/kGojvl7qdg/3aiy91GRTI fEywq5JAuuiksd99iIwKQWoJ6MOWCjvPJ4z8L3XwBxmW0xc2bfzxEfKNaan8w1MXUqKU ttSjmWsT/eljf57OuCu07pXlG4u3hDpjwAdHG1ls4vuJkiAbf7hpM1Sz7oN5ohVvtDvd +/CZsnX1/vtwn+N1an9W7QpoWZ8NK69QSUF7TzaY+LBNrRBe7WAwpAwCwWJO4UaWmxas iDcSMP+vahewsa/hcLdhp13te6WlSnselbK1Hf0vGFJg2Qkmiomq6B8valb48bpeQfo+ TooQ== X-Forwarded-Encrypted: i=1; AFNElJ/P25L5KFVysoGv72BWaT2819lSp2Ex6Gk2640hShugGBKKrySTzMQPexvr9qLVIhmexM52J3IapjRG4lbN@lists.postgresql.org X-Gm-Message-State: AOJu0Yz4N+G0QiRnDctIscEoShWTRokDD2awANC/XSFALcenYal49an/ ZP5PpFQRroW1+BKcZy1bp8HwpRZk6/F6WdAdbtrGAL3GIKX+ILv3/WKBZecH9Zjr6dyz1eT0zkm s1awbMQCDGBLayxOkWJhLDICnBdiQNa4= X-Gm-Gg: AfdE7clzPAyHt4mwL+oXlgaSP8uP/B9o5JwgHYSddP14k1/vNLJrQfwtMy31ls9HIBf HJi/EuEqnubsUQ+9mgUQb3hpUDJs3IubIbIt8A7S1Db9jA87smzkZBznl7YI/rjcxSPcgtE92n5 xyoBH9ThH9opVczAhADI1ZExKzCiw3hE1rivGQWzdn8ljG0rmafUYl7gcq1HR6cvUg71y9+prUw Y5OAvD+Ub4J9M55jby1MWFSd2tkNJPGtzNhaIoYSxrVqaA4nwt4GKY8RF/BGD5AqoFEPxUCsaWH aAlU1MS0m3FxuyrVULSx5zgdJ9ycBRC8Lg7Ll/lKAsDiT4KRy2A= X-Received: by 2002:a17:902:e5c7:b0:2c6:ab5b:7579 with SMTP id d9443c01a7336-2c718f5e216mr35571335ad.27.1781872637894; Fri, 19 Jun 2026 05:37:17 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Fri, 19 Jun 2026 18:07:05 +0530 X-Gm-Features: AVVi8CcZ60wthsTo9vtfJJrjTlFFfwRBwa7E4UxbgEy0rA6JY9aV202WbLExjG0 Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: Nikhil Shetty Cc: Dilip Kumar , Shlok Kyal , vignesh C , Peter Smith , Nisha Moond , Amit Kapila , Masahiko Sawada , Bharath Rupireddy , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 19, 2026 at 5:57=E2=80=AFPM Nikhil Shetty wrote: > > Hi Dilip, > > I was just testing this patch.I was thinking if we can have another colum= n which stores the timestamp when the conflict happened. This will be usefu= l for debugging purposes. > We discussed this earlier and plan to consider potential approaches once base-patch is committed. See the discussiosn around [1] and [2]. [1]: https://www.postgresql.org/message-id/CAJpy0uC54cxVYNRTfFXY_986-54HTVD= NE1srn_Z9pGGDYhDjcw%40mail.gmail.com [2]: https://www.postgresql.org/message-id/CAA4eK1J0PJHR8XMx3zRyBkhVHkKAcMf= qXT20t0E8qievY81LOw%40mail.gmail.com thanks Shveta