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 1wbaB3-002gIs-1D for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jun 2026 08:38:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbaB1-005TNI-37 for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jun 2026 08:38:43 +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 1wbaB1-005TN7-23 for pgsql-hackers@lists.postgresql.org; Mon, 22 Jun 2026 08:38:43 +0000 Received: from mail-pf1-x435.google.com ([2607:f8b0:4864:20::435]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbaAu-00000001jB0-1Lft for pgsql-hackers@lists.postgresql.org; Mon, 22 Jun 2026 08:38:38 +0000 Received: by mail-pf1-x435.google.com with SMTP id d2e1a72fcca58-84347ad88edso3411564b3a.1 for ; Mon, 22 Jun 2026 01:38:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782117514; cv=none; d=google.com; s=arc-20240605; b=i8qlAz4lQ9OWZvsK0egNBF7sn3wiz+RQWx3thgyHqFlhTAuCIjDIgVDLxffU42kvxO Zod8909XaHFGg9Qqzsc7yZHYS0yovG0929pnsJKGNfRPXy6wZB/xy5R/eIQnNo3f0BrE TL5q9MQVbUUA+M9et/pCsfHFKk4C15kKYCfssajtrIODukpcYnTUBNKCoEKFNidQxDLM d+GuFCG79olXwrfqb1kBWRdTjIF4i72YpZWbIG7b26l5KRHXNU+Rrw/dtze4CPE5t9TB squFsr/VCUjk8gGCY5vHIpURg24W0TALWd/B64/e+QmxmTAV7b2pIZMr7sBEjpKHuteh ouRw== 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=Vor3xeG+IiiB+cCvqCjIgmj3l7GdszEcJgiSLk0CWeY=; fh=fIEXqIfnZOMdhotTZ0/+cBRr8Ro5Ou7KdEk6P2MPBZc=; b=SuHHTS3FsdSPyRTS4f0KZscY2RDdTwBCY+8UgHjzvjjBmf+q2hKzuj85dOtQW7PS+d dXf07vZPuVuGyTZ3ogF9StiZC545Hniv8v8EITdLIJYjNmk6/HubtnVEPH8s+JsxrG2Y UUY7c3k5eu6CrpWudzAhmW1TCCvqwQdId6jG3D2hZnYOYPcf4Jg7lKrdNrrY/rKHPQlG K/BxELCuTS0tixTq903nM8a/dtGOH/sROP85/qPhU94kD9mERB9t5EjybKCmIL4pf00u z0eGwXeVtMY5MU5WtQd0fUSPc1KFzY5ywGxRxvz3XwY3M9G3t9mPMBFqAzUlwnnhL+QG T64g==; 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=1782117514; x=1782722314; 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=Vor3xeG+IiiB+cCvqCjIgmj3l7GdszEcJgiSLk0CWeY=; b=MSz78beuftuj81DxtELRyhs0SzVbgwLBjlefbrwmmrPw05bYV6Q4wR/ZAqWI7yDxbQ aB8oDHlyQHWBDQGTR0QjfmaJWNOwbJZsZIqGgIBEs+fQ+AO7cROV6k5AL1PSwKExOkEF m0EUbDmW5YB19MnMImGS0B1zLJTNkQbzANtpPXwYSw1lR20RmJ3yiqVg1hrOJFWKLpgI JDVsn+9wXMeJ4Tp09mbbTAx2Jh/BIKdK/dUQbcVa9h0j/Ov6JBJkM6rwanDTz4/kj+TP SyXKGpS0fkfam0b46cUOZNXHP+lupWPMK376+crAla2wt+G6ySWgTMZoJAetP7wai7qu Qb7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782117514; x=1782722314; 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=Vor3xeG+IiiB+cCvqCjIgmj3l7GdszEcJgiSLk0CWeY=; b=sIsZegbClcfDk2Zm4ks/2iuLx6HHWxbt70ORcImoaJ9+gUm4ap6yMjXNl/9OIBMPs/ I5Bj7uhtNp0uSWDmSZJZ2byF4htmSJaK+xoHr8CGMOMDHYWzN0Ulf3sqVzFyuCltIGDt ktKoDgvOo7f0IniDyg705S98X1k4rGEv3lwEwYOMq3WtKfXM/FERofATfeFKVJ+tfhg7 t3s0YgkC65F/c5kV2INiIkHoi9cBv7q/9w/1aybaqxn0vHuOxZ6GgurfuKVjMffNK4it 8fCs07UNpK+rKkEXBfdg2jwukeelAlsZV1q6YV7WCqTOacwCpbql6in3faZYNS+3GCiW oJqQ== X-Forwarded-Encrypted: i=1; AFNElJ/BdQPxCMF6EpedHshBqMsDS7ihy9o7H1WNyRnDNcjT3LqbEKqRCjzOA10P/jMLQa1w0UU+WXwKfN2YQ9Eg@lists.postgresql.org X-Gm-Message-State: AOJu0YzDmYo3TBFTv8UrC2jDK8PXe0iA8hdvSXpxCWAEVsFJJrRsIjpM a+bf7wMF1aTgnvkA5sechrZNreEu4BcWUHmwjPF1G8MWozHjL4U8WYQkf/a67M/2DPtRfsAu3He jWpKCoJJfpdvbF5fOO/Ojkk9PqMWHPTo= X-Gm-Gg: AfdE7cm9rorgkNaA/OjFRfrCIlYzxnDh5LdenZXYpYpn/NXGfjt6qWDylFjCuG06uUD DhNyzJsLk49i09oHo0bawzXCADHLQKiEmkcfb4aR1sAaG0WWsoy4HrW+tlDPaOeZPQryw6OWiaF /SYWtgUtStPCWKXz9Yl3+Hy4hcfBo0zxjmEn3Ydb0oVnH35agk92MZbKDAwj7c2jYk89YVhs6iY zvpWWUjlZ6QylvUhsi85PGPds7hccuiD8xLDX5haJogexsgUWm6jDwvAzijjWF1rBPglY97jN4J GCH2wSQJm8gtdHkYYodZGdtUgvFcyBZXI5V9wl58 X-Received: by 2002:a05:6a00:14cb:b0:82f:50cd:e586 with SMTP id d2e1a72fcca58-845507c1c1bmr15056631b3a.13.1782117514286; Mon, 22 Jun 2026 01:38:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Mon, 22 Jun 2026 14:08:21 +0530 X-Gm-Features: AVVi8CcbXEKF4pT_WY3lk6xRjufCQlDQFPnKMN6OIuPjqktkyI9PiGEGJLPPrUA Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: Amit Kapila Cc: Dilip Kumar , Nisha Moond , vignesh C , Peter Smith , 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 Sun, Jun 21, 2026 at 7:19=E2=80=AFPM Amit Kapila wrote: > > On Thu, Jun 18, 2026 at 9:33=E2=80=AFAM shveta malik wrote: > > > > On Tue, Jun 16, 2026 at 6:54=E2=80=AFPM Dilip Kumar wrote: > > > > > > IMHO we should just log WARNING and continue the apply worker on > > > conflict insertion failure, lets see what other thinks on this. > > > > > > > I have the same opinion. Allowing CLT to block the apply worker would > > be undesirable; CLT is a history/logs collection feature and should > > not interrupt core logical replication work. > > > > I think the insert can fail in rare cases like disk getting full while > writing WAL or some internal memory ERROR and the ERROR could be > persistent which means the LOG will be filled with the same WARNING if > there are many conflicts. Also, users may not like missing out on > conflict information. So, we can ERROR out and let users fix the > situation. Okay, that's another way to look at it. I am okay with this approach too. Thanks, Shveta