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.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1ugmMv-007Gdg-Uo
	for pgsql-general@arkaria.postgresql.org; Tue, 29 Jul 2025 15:35:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1ugmMv-002arH-1s
	for pgsql-general@arkaria.postgresql.org; Tue, 29 Jul 2025 15:35:57 +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.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1ugmMu-002ar9-Nq
	for pgsql-general@lists.postgresql.org; Tue, 29 Jul 2025 15:35:57 +0000
Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1ugmMt-001P5I-1B
	for pgsql-general@lists.postgresql.org;
	Tue, 29 Jul 2025 15:35:56 +0000
Received: by mail-wm1-x32a.google.com with SMTP id 5b1f17b1804b1-4561514c7f0so54935855e9.0
        for <pgsql-general@lists.postgresql.org>; Tue, 29 Jul 2025 08:35:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1753803354; x=1754408154; darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=2vmyPBbcjzuCEhr9A+/W/+m8sWy6xRFsMmeeNMiWZRs=;
        b=Zcg2ZSm43rQdpmC3dYwXfeJ/xhuxYtN0jwiVuqK8B1XLUU5mn/fbSISnlIzgbZ33AG
         UqJIw+NpZtZNModvPyvVCVqYj69PZr4z9w1D/1G9j532L/NCg3SIEVeJsaTHtloDINOj
         Xw3MRfdrdez/mxZ5je2EX72i4UKVf/AX08q31flYu4Eihp2CgzjBymkP0O5bBdDmjxGQ
         fj4J86a5lu/Yp60X2hiKlaT9SlGm9rO9J7Yq25lx54jRrxbOBo9T5tnOfcegCcMYvswx
         67vggNaLMqFD8LhzG7BNoA9A0RUAnOZUfMu+pO5kzbfamFdpTK4O9f94SPRdNJof6+/M
         PUBA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1753803354; x=1754408154;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=2vmyPBbcjzuCEhr9A+/W/+m8sWy6xRFsMmeeNMiWZRs=;
        b=pRfMMbdb+khWFhgTIXKwnVkmFlDQbdn11e1d5nZZjCdUVQ5zFWkwZ2qwyIz6Rq6CtB
         le6XqsLuyQPRzbbwUkXlAIXukh0yg3hZSXlHNysIgERm/8LnnAWoJdYKKg1365vjrfk+
         +oCfBJXKvTQrOL3hhWYrcjsZnpAFPdCIeG9zKkWcFYsuiz9XHfKcn4+6WPKP+CMfIzAh
         wF6jtIeCy7RVlfmtX+tSLDwNxdtZl5zVTBiy8SdwhKJUBz39e/aghIErVleDH6vCONRZ
         xDaTPxbxnTPJzBqLk1oaJXI1kH5zbzeH+pW5q/ztk4BqW1nf75/jWjV0noU0aEbuDL+I
         A4Dg==
X-Forwarded-Encrypted: i=1; AJvYcCWT/05RGMtLKXRldnN8fxxZIi3aywI9g5Yx9jGMvTvwZ99n82HWDWqC6dCAMzTHBp0Rfh5CxATvHMbQfF3v@lists.postgresql.org
X-Gm-Message-State: AOJu0Yxke5CpgZLXYmQkG40rXFyoKpPwkCqVoJN4/FIFXX3zF5Gu2tXM
	ksmQssnj0MDArrYqzWbxRVyQ7rix03d2geS7o6lTxU9qpFuOefRsydl/DbwNfeZCOGs=
X-Gm-Gg: ASbGnctlxDdX/F3nZNOW3BHgVWHiKvuEW0glLu1RDIEfPKBHDO9F+bpoD9HSdbTE/qS
	XqrfU3dbeuzFDPVycPg6JRC289Nzry3DYTp9hoh5dROkccIch1208hTSb1qH7mN1uQuxHBQhGY+
	RnFft8xvsnCSpfXu4jAFkWxpoKXZOb94HViIxsc553h5A8HxMRRE0yvCeOhByEntQYButzl50k0
	fQQl0xIXFmzQ8aQzhJFnqJtnAnL5SuBwYQL6us58rrVDbaWXOhH3MAuHX4X4xS2bNOdgk4m92nk
	ZNLfvRzWqVSUGLKVLBFWpeDKZtr7UhoJUPLmAjO6Z9f9UCAR69/ecJruWw7BeHOuZWUhWkUPfkV
	nx5eS17pnmHf48+5u9PfUsBlcuYb2Xjogm/TlV69Fpa3d0Ki/FENI
X-Google-Smtp-Source: AGHT+IG0wkJPhrAW+kDCBB0pbamyvZDzATYibdEMYYjeRgWv9YQ5QEsioZzeBzPV/V2B0x7L2enCaw==
X-Received: by 2002:a05:600c:3e06:b0:43d:3df:42d8 with SMTP id 5b1f17b1804b1-45892b90f08mr2606275e9.6.1753803353677;
        Tue, 29 Jul 2025 08:35:53 -0700 (PDT)
Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:9b8a:5191:4127:e9f1:710b])
        by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-458705bcbb7sm211689755e9.18.2025.07.29.08.35.53
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Tue, 29 Jul 2025 08:35:53 -0700 (PDT)
Message-ID: <9ee5c6b3902eaf4aab7615cedad39696b8799246.camel@cybertec.at>
Subject: Re: Regarding logical replication issues with PostgreSQL versions
 16and above
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: yexiu-glory <yexiu-glory@qq.com>, DINESH NAIR
	 <dinesh_nair@iitmpravartak.net>, pgsql-general
	 <pgsql-general@lists.postgresql.org>
Date: Tue, 29 Jul 2025 17:35:52 +0200
In-Reply-To: <tencent_E04ABD6C09BE6D0FE0302F54A1DF5C6F1E08@qq.com>
References: <tencent_2EDF6F264A6F6C92BE540FC63078544EDF08@qq.com>
		<PN4P287MB4381FC07BE93E47F5EC1DC0F9C5AA@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
	 <tencent_E04ABD6C09BE6D0FE0302F54A1DF5C6F1E08@qq.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/9ee5c6b3902eaf4aab7615cedad39696b8799246.camel%40cybertec.at>
Precedence: bulk

On Tue, 2025-07-29 at 15:00 +0800, yexiu-glory wrote:
> The approach of adding unique indexes is not suitable for our business.

Well, then I guess that logical replication is not suitable for your busine=
ss.

Yours,
Laurenz Albe