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 1waZF5-001te2-38 for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 13:26:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waZF3-00GEIO-0s for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 13:26:41 +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 1waZF2-00GEIF-25 for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 13:26:40 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1waZF1-0000000191k-17a8 for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 13:26:39 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-695bba79ae1so2970693a12.1 for ; Fri, 19 Jun 2026 06:26:38 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781875596; cv=none; d=google.com; s=arc-20240605; b=DqFpRwWwarr+xuI26QAC4Cxbl5GSKVYs8UBJFF4dUsH77nrusDeZS//SEktQmuVwdn wBcJusIO9AiYicTpzAjCME3PfKhZfP01iyIk6C86rB58tZqnkzdoUFsWDHae0vL2NZzG Rvpymf55rL/qyKBu0YfGKPkHnuDOxkpu57WLWMl9muwgh3lr6nbKy3PO4mmchtn5hKS6 4vrNx497xGS1ggHlRKY7u9IK4Qe5f7MIfIU8bFO7gCspRLyRn7q4oTldSmO9xYx3l99o nlrGy0i1JKdocaktyAPMEeQGtgFFGsfZQ4O0qCZsHBDJ4r+D5xkJh+1kRyriIqiT6AUF anmg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=0/t09zxvr4sJhRcAvEyXusDBaJHBN0T/N9EsR0rckkw=; fh=tEL5ym58ocV3tdWUQKijsZiqmaA+9UmyQMM7+pZI9KI=; b=PaNGuHD4YOoXReJpih+hQlfvN8NcKPcz4tiRitjy/F+SqWz0N61YbbCzjM5PbYCfsN V/2Cz5Km3ngycNckaEXu7WSpAhzWQY6emdPb4pnv+iT8yk6CimLZgTnIMASRsuTJwipW EN5XR9hdKN0OmDqmMAHyTpVNdqSXXqbAorN+fA1uWP0V28cZ6zIS78uD7voXxHKQzD/R rJU6koaP8EwjYBQ53ky9I6LjUdr5dKmHszX549szjzr6f4in4K2Tww5F4PcBRMcTwiRJ l+t6kyAtqm1kLtwdyxStC8S369YO7Vl9MxVikwRm3WLOvWcffPFG2CvkFtDl4zlTcE4p 78Xg==; 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=1781875596; x=1782480396; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0/t09zxvr4sJhRcAvEyXusDBaJHBN0T/N9EsR0rckkw=; b=cfgEHJWxzHvbhHlo9ml/VegLPsLRsYgXbCxHKXGZWZndQmGuAqwxZomyXgQI3pQyfL V5ESteJdAA3LVs1i2ymY6f37L1Ipyb3n1LwmUgNF674hvPSv4KM6wN3lVg9RJz4Pq3uJ 0eGloPGxLWUAa4XA5WaJi8CIUazGI/IVvNNyUeZk20PLNV/4pbxtGjVMkbZgxeZz0LEG SxMWwmT6jR5PxGm66ashEQ1XkNI7Ez0yNiQ4kgzO7QUoOUo1w37YGu44KQEHQZobh1ba UqP6K6Rk2CUnB8TFHk8sj+6s7FgDOPFgzKeIXbp/FCILmgH4CWyx7zg9SQrCA5vTGbH4 9s3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781875596; x=1782480396; h=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=0/t09zxvr4sJhRcAvEyXusDBaJHBN0T/N9EsR0rckkw=; b=hS++Ln1MYEJVO07k4GRpsZFrw+O8QXVBFtD2JhZjtm0ZBLXl9mKioUMmFJIuHmIUyt vRBkARtDz+Yjgs06gfkcYJigyCHRfCBtdlEDYg5R7na+eHCSrqLnx9y+dQHxPwxCt34e LHc9aLz7EtoQQKGysb7DNjZHr5/V2GgXSPztIwXrXrh1NdKLpX4jwDUfeSdmmK9LqJjG anPjqPFy1+K4rzQXACK7QGoOgt8LRVVL+2goSqHLKqQ0TkMfUnyjSekHPfuLNm1Asl0d owTG78w6mnbJtNArb7LWxHUZD33MxKbFEsU07GIfJmynzsnPuG1FIodDw44kA7WZkCan r9xA== X-Forwarded-Encrypted: i=1; AFNElJ9MS2H3hj692CCGgZCyqra67gqJ8DvALrGWez/FKc4z+EuxiUzLkDSfYWnQjY1gDkx5gH2Y1m/PHqp/UHmg@lists.postgresql.org X-Gm-Message-State: AOJu0YwkOHUFYZ1w62bFrgxhG7Ex9e2euF8FbJpg11TnmsaJxp4FvKgF /+ZUlF/zImz/0Qmrr6PjCPzElLDLohqwyqgewsX293Rv5SAeKidO3DSiiK2w17efyIPaGloa8i9 gntTyQ6Sc7K3tWE2FCWbFtyC691yTzzI= X-Gm-Gg: AfdE7cnYfMZugR13UMRTEE+a1TIySkQbphoIgBsYTeejjsFx6ZXKVHysLPKy7amZR++ AYfnVAL0Kxfur2ihIsY/B5wkk3mEk05iFNjn23x686rkrrS+lpdT1u6EjseZvYCITFiIBCBuHcG 1q9Cn87tIEdA4eaSAdAlGnsY90Pwd8fBIuKiVb//h3TnbIBjZwrHGJHIlYiuKGAtxJ/f7cBLHwq cBEoV6cQg3PIQYFO6kWr8JG/pX/OZMMn4fQzBjVi6AAa+x8O7Oc+zmJwqBfWoEkLkkJmn71sC95 3t6UOUgOhsFgwl5k74UHYcxhLvdhcwNChoeBccAvMQ== X-Received: by 2002:aa7:d31a:0:b0:67c:34bb:1bd1 with SMTP id 4fb4d7f45d1cf-6973b0a396bmr1111677a12.1.1781875596007; Fri, 19 Jun 2026 06:26:36 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Nikhil Shetty Date: Fri, 19 Jun 2026 18:56:22 +0530 X-Gm-Features: AVVi8CcGY3SQhR8egRX_lxT8al57EUFdn1ZMbF6CwV4npt5iyQI7dEL-qa--uGE Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: shveta malik Cc: Dilip Kumar , Shlok Kyal , vignesh C , Peter Smith , Nisha Moond , Amit Kapila , Masahiko Sawada , Bharath Rupireddy , PostgreSQL Hackers Content-Type: multipart/alternative; boundary="000000000000ef1ca306549b3d9b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ef1ca306549b3d9b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I see, thanks for the clarification. On Fri, 19 Jun 2026 at 18:07, shveta malik wrote: > 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 > column which stores the timestamp when the conflict happened. This will b= e > useful 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-54HTVDNE1= srn_Z9pGGDYhDjcw%40mail.gmail.com > [2]: > https://www.postgresql.org/message-id/CAA4eK1J0PJHR8XMx3zRyBkhVHkKAcMfqXT= 20t0E8qievY81LOw%40mail.gmail.com > > thanks > Shveta > --000000000000ef1ca306549b3d9b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I see, thanks for the clarification.

On Fri, 19 Jun 2026 at 18:07, shveta malik = <shveta.malik@gmail.com>= ; wrote:
On Fri, Jun 19, 2026 at 5:= 57=E2=80=AFPM Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
>
> Hi Dilip,
>
> I was just testing this patch.I was thinking if we can have another co= lumn which stores the timestamp when the conflict happened. This will be us= eful 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= -54HTVDNE1srn_Z9pGGDYhDjcw%40mail.gmail.com
[2]: https://www.postgresql.org/message-id/CAA4eK1J0PJHR8XMx3zRyBkhV= HkKAcMfqXT20t0E8qievY81LOw%40mail.gmail.com

thanks
Shveta
--000000000000ef1ca306549b3d9b--