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 ) id 1vHIAS-002hxQ-Vq for pgsql-general@arkaria.postgresql.org; Fri, 07 Nov 2025 08:50:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vHIAR-00DBBh-MN for pgsql-general@arkaria.postgresql.org; Fri, 07 Nov 2025 08:49:59 +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 ) id 1vHANF-00B611-I5 for pgsql-general@lists.postgresql.org; Fri, 07 Nov 2025 00:30:41 +0000 Received: from mail-il1-x12b.google.com ([2607:f8b0:4864:20::12b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vHAND-005onF-1h for pgsql-general@lists.postgresql.org; Fri, 07 Nov 2025 00:30:40 +0000 Received: by mail-il1-x12b.google.com with SMTP id e9e14a558f8ab-43323851d03so906595ab.0 for ; Thu, 06 Nov 2025 16:30:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762475439; x=1763080239; 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=MQCKIwS2sxGPtUvQwcSi1q9/XQ07gIb5Uavz1OFQxqs=; b=J2sh2f7XtahcnRpuD2O2KLV1go/CUb2+t2tNv1KhCZQ7aQWxHOEoQgzgYwLJw9LSex mR0R7ECSXr9nZ0khhUoZgb0IcjANaP3mXTOWc8BcXvhEHQHeGMDmOxRGc0abeb8uUFPB CSUD9epVNGQ/gPDYlKtULEWzfpbcB9g2V/lMOgn1ogTqNXWpFNQngAZIPEaIxTtmXuKp tgJtpZ0MTfsGFMqW5W13KtYJllfwjvpTbb5R0GXMXUJrdOwFQ9s8ePZNRiubwEQK2bLX flJN3Y0ZOO5+jeR6zEcKlx6fWNNGlIpMX6Do0oWIlBS8KKLl5x95w04XsDBXLPUjxG4B lNlA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762475439; x=1763080239; 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=MQCKIwS2sxGPtUvQwcSi1q9/XQ07gIb5Uavz1OFQxqs=; b=KZQ2mh+FTKhze34JcwHiBw2UQ2oQklmbAQirNp06k+8OKGtOsRheVSpXBVmOwXw4f0 kRV70vQlYejGMfRJS32/fZxbG57yN6zojZRywl4MfCzMyyRtmZg46z4SkUVKQaqVHE5/ 4Vw64CXC+QF6Sk9eU3WSwksyL/2mge8r8SAadj9OIqtxm/Sh8YsIUF9Q94mq77S/lijt 4nzOSIPFO7ZiTB0AApDc0z/tcHZge1R9Yl8SqSfGpfvlxHYzCbyvqAYTA3DqYlryQp9Y 21H86LjHhrbgpCMcp9j7dYN1v4UBI3aUmIYXqgFphq1+IZSqIhYcYtgWOXLOhMPJ0/FT uppg== X-Forwarded-Encrypted: i=1; AJvYcCUq8S2iRpQOAAQdi+apD1ddEMwIotWExeNq4XSibvTktsgZTvmBqTP8xr8BtPSXm39DD7hxF0BqhOam2S1p@lists.postgresql.org X-Gm-Message-State: AOJu0Yx0NbWCCVyJDvohQDtu+gMM8gV4u4DHCIuzchtBeBI9YZsmbCkh oTvwPBC0gdrY/CaubQPZ6cdUyXyoM1dzs5HHbT+Sz358HIewjg4WDKXXGAlJF+CDieVYiBKXTkr WBrOI00KL8lVmucYik2AD7zRk/Q53xZM= X-Gm-Gg: ASbGnctFwJxc3L3V09aiuFgz83y87kj6eeaB4tR5VxPGh6BlAYwrLG3uWHn/trXzpgA ueQHm/6bBE+zS9X0PnnwxUSMv7zQavHtnHm3vSGnkBKqwlTjygbkEM9pJZo7WL0IjEb2tckwTiU m66vjdXblDbf/LNN3LJzzlcbLbeC9wHcKBRWPwBiggUpE8jOz/1UBFq8KZKAvU1wucHUoSmK8RJ NdwK3V/UbSG4YPyEcJwD6uJmqqkFqFtxej0QN/9Nbimf4pxrhz8LCFu6Rv9kA6QSj1lTFbveOLC 9zQYgE+l4pVObLP2Vw== X-Google-Smtp-Source: AGHT+IGXIUZL1KTdJMWP5D7P6f+3rWcqDoC9RoJjtQBQvu/2B9W1Ek2HVs82c6qNg6Gfy4GvdZ0/8sTNKlHtRbwSFuY= X-Received: by 2002:a05:6e02:180d:b0:433:5a9d:dac6 with SMTP id e9e14a558f8ab-4335f4d5b6amr20229075ab.27.1762475438688; Thu, 06 Nov 2025 16:30:38 -0800 (PST) MIME-Version: 1.0 References: <942b979a-c5e8-40e7-bdec-0234a0e5a010@aklaver.com> In-Reply-To: From: Bala M Date: Fri, 7 Nov 2025 06:00:27 +0530 X-Gm-Features: AWmQ_bmqfHCOKoIazh3YCZN6xSsYzRfA8HWmPTmBeZaUs08Cg8D5CLFBtZc2T1Q Message-ID: Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) To: Adrian Klaver Cc: Greg Sabino Mullane , Francisco Olarte , chris+google@qwirx.com, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000072ce9c0642f64aac" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000072ce9c0642f64aac Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable *1) Show how you have set up the publishers and subscribers.* We have configured logical replication between PostgreSQL 11 (publisher) and PostgreSQL 16 (subscriber). Publisher: PostgreSQL 11 with wal_level=3Dlogical, max_replication_slots=3D= 20, and publication created for all tables (FOR ALL TABLES). Subscriber: PostgreSQL 16 with max_logical_replication_workers=3D16, max_sync_workers_per_subscription=3D8, connected through a subscription to replicate all tables. select * from pg_publication; pubname | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate -----------+----------+--------------+-----------+-----------+-----------+-= ------------ test_v_pub | 10 | t | t | t | t | t (1 row) select * from pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn -------------------------------------------+----------+-----------+--------= +----------+-----------+--------+------------+------+--------------+-------= ---------+--------------------- vahan_sub | pgoutput | logical | 16468 | test_v | f | t | 3722767 | | 3146687395 | 20538/7D039948 | 20538/7D045790 pg_120870_sync_94301_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/71C4FD28 | 20538/71C4FD60 pg_120870_sync_93499_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7D039948 | 20538/7D039980 pg_120870_sync_99121_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/6F290C88 | 20538/6F290CC0 pg_120870_sync_108854_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7C6B5FD0 | 20538/7C6B6020 pg_120870_sync_93451_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7D0359A8 | 20538/7D0359E0 pg_120870_sync_94589_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/4C0001E8 | 20538/4C000220 pg_120870_sync_98225_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/6F290DA0 | 20538/6F290DD8 pg_120870_sync_96438_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/75CE4120 | 20538/75CE4158 pg_120870_sync_93469_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7D00E0B0 | 20538/7D00E0E8 pg_120870_sync_94277_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/4C000178 | 20538/4C0001B0 pg_120870_sync_109085_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7B72CFE8 | 20538/7B72D020 pg_120870_sync_109110_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7AE3B078 | 20538/7AE3B0B0 pg_120870_sync_99247_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/4C0001B0 | 20538/4C0001E8 pg_120870_sync_103454_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7D0002F0 | 20538/7D000328 pg_120870_sync_96317_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/71C59D20 | 20538/71C59D58 pg_120870_sync_107790_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7A4102F0 | 20538/7A410328 pg_120870_sync_98730_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/6F00CE40 | 20538/6F00CE78 pg_120870_sync_93488_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/7CF2C4F0 | 20538/7CF2C528 pg_120870_sync_103457_7567666078127625550 | pgoutput | logical | 16468 | test_v | f | f | | | 3146687395 | 20538/6F127188 | 20538/6F1271C0 (20 rows) postgres=3D# select * from pg_subscription; -[ RECORD 1 ]-------+------------------------------------------------------------------= --- oid | 120870 subdbid | 91683 subskiplsn | 0/0 subname | test_v_sub subowner | 10 subenabled | t subbinary | f substream | f subtwophasestate | d subdisableonerr | f subpasswordrequired | t subrunasowner | f subconninfo | host=3Dxyz port=3D5432 user=3Dpostgres password=3Dtes= t dbname=3Dtest_v subslotname | test_v_sub subsynccommit | off subpublications | {test_v_pub} suborigin | any *2) Are you trying to replicate everything at once or a table or subsetof tables at a time?* We are replicating all tables at once (full database-level replication), not table-by-table. *3) How active is the source database?* The source database is highly active, with continuous transactions and heavy write activity across large tables. Thanks & Regards Krishna. On Thu, 6 Nov 2025 at 23:53, Adrian Klaver wrote: > On 11/6/25 09:04, Bala M wrote: > > > > Hi Adrian, Thank you for your response. Please find the requested > > details below: > > > > > Since you have already started is that not already to late for this= ? > > > > Yes We are currently in the *testing phase* and validating with the > > above parameters. However, the replication process has been *extremely > > slow =E2=80=94 it=E2=80=99s been running for the past 5 days* with limi= ted progress. > > 1) Show how you have set up the publishers and subscribers. > > 2) Are you trying to replicate everything at once or a table or subset > of tables at a time? > > 3) How active is the source database? > > > > > Any specific tuning recommendations or best practices to improve > > performance at this stage would be greatly appreciated. > > > > > > Thanks & Regards > > Krishna. > > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > --00000000000072ce9c0642f64aac Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

1) Show how yo= u have set up the publishers and subscribers.

<= div>We have configured logical replication between PostgreSQL 11 (publisher= ) and PostgreSQL 16 (subscriber).

Publisher: PostgreSQL 11 with wal_= level=3Dlogical, max_replication_slots=3D20, and publication created for al= l tables (FOR ALL TABLES).

Subscriber: PostgreSQL 16 with max_logica= l_replication_workers=3D16, max_sync_workers_per_subscription=3D8, connecte= d through a subscription to replicate all tables.

= =C2=A0select * from pg_p= ublication;
=C2=A0 pubname =C2=A0| pubowner | puballtables | pubinsert |= pubupdate | pubdelete | pubtruncate
-----------+----------+------------= --+-----------+-----------+-----------+-------------
=C2=A0test_v_pub | = =C2=A0 =C2=A0 =C2=A0 10 | t =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| t = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | t =C2=A0 =C2=A0 =C2=A0 =C2=A0 | t =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | t
(1 row)

=C2=A0 select * from pg_replication= _slots ;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0s= lot_name =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0pl= ugin =C2=A0| slot_type | datoid | database | temporary | active | active_pi= d | xmin | catalog_xmin | =C2=A0restart_lsn =C2=A0 | confirmed_flush_lsn-------------------------------------------+----------+-----------+-------= -+----------+-----------+--------+------------+------+--------------+------= ----------+---------------------
=C2=A0vahan_sub =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | pgoutput | logical =C2=A0 | =C2=A016468 | test_v =C2=A0= =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | t =C2=A0 =C2=A0 =C2=A0| =C2=A0 = =C2=A03722767 | =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7D039948 | = 20538/7D045790
=C2=A0pg_120870_sync_94301_7567666078127625550 =C2=A0| pg= output | logical =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/71C4FD28 | 2053= 8/71C4FD60
=C2=A0pg_120870_sync_93499_7567666078127625550 =C2=A0| pgoutp= ut | logical =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7D039948 | 20538/7D= 039980
=C2=A0pg_120870_sync_99121_7567666078127625550 =C2=A0| pgoutput |= logical =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/6F290C88 | 20538/6F290= CC0
=C2=A0pg_120870_sync_108854_7567666078127625550 | pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7C6B5FD0 | 20538/7C6B6020=C2=A0pg_120870_sync_93451_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7D0359A8 | 20538/7D0359E0=C2=A0pg_120870_sync_94589_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/4C0001E8 | 20538/4C000220=C2=A0pg_120870_sync_98225_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/6F290DA0 | 20538/6F290DD8=C2=A0pg_120870_sync_96438_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/75CE4120 | 20538/75CE4158=C2=A0pg_120870_sync_93469_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7D00E0B0 | 20538/7D00E0E8=C2=A0pg_120870_sync_94277_7567666078127625550 =C2=A0| pgoutput | logical= =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/4C000178 | 20538/4C0001B0=C2=A0pg_120870_sync_109085_7567666078127625550 | pgoutput | logical =C2= =A0 | =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | = f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 = =C2=A0 =C2=A0| =C2=A0 3146687395 | 20538/7B72CFE8 | 20538/7B72D020
=C2= =A0pg_120870_sync_109110_7567666078127625550 | pgoutput | logical =C2=A0 | = =C2=A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2= =A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0= =C2=A0| =C2=A0 3146687395 | 20538/7AE3B078 | 20538/7AE3B0B0
=C2=A0pg_12= 0870_sync_99247_7567666078127625550 =C2=A0| pgoutput | logical =C2=A0 | =C2= =A016468 | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 = =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2= =A0| =C2=A0 3146687395 | 20538/4C0001B0 | 20538/4C0001E8
=C2=A0pg_120870= _sync_103454_7567666078127625550 | pgoutput | logical =C2=A0 | =C2=A016468 = | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 = =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| = =C2=A0 3146687395 | 20538/7D0002F0 | 20538/7D000328
=C2=A0pg_120870_sync= _96317_7567666078127625550 =C2=A0| pgoutput | logical =C2=A0 | =C2=A016468 = | test_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 = =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| = =C2=A0 3146687395 | 20538/71C59D20 | 20538/71C59D58
=C2=A0pg_120870_sync= _107790_7567666078127625550 | pgoutput | logical =C2=A0 | =C2=A016468 | tes= t_v =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0|= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 31= 46687395 | 20538/7A4102F0 | 20538/7A410328
=C2=A0pg_120870_sync_98730_75= 67666078127625550 =C2=A0| pgoutput | logical =C2=A0 | =C2=A016468 | test_v = =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 314668= 7395 | 20538/6F00CE40 | 20538/6F00CE78
=C2=A0pg_120870_sync_93488_756766= 6078127625550 =C2=A0| pgoutput | logical =C2=A0 | =C2=A016468 | test_v =C2= =A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 314668739= 5 | 20538/7CF2C4F0 | 20538/7CF2C528
=C2=A0pg_120870_sync_103457_75676660= 78127625550 | pgoutput | logical =C2=A0 | =C2=A016468 | test_v =C2=A0 =C2= =A0 | f =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0| =C2=A0 3146687395 | 205= 38/6F127188 | 20538/6F1271C0
(20 rows)

postgres=3D# select * from= pg_subscription;
-[ RECORD 1 ]-------+---------------------------------= ------------------------------------
oid =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | 120870
subdbid =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | 91683
subskiplsn =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0/0=
subname =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | test_v_sub
subow= ner =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 10
subenabled =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| t
subbinary =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= | f
substream =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | f
subtwophasestat= e =C2=A0 =C2=A0| d
subdisableonerr =C2=A0 =C2=A0 | f
subpasswordrequi= red | t
subrunasowner =C2=A0 =C2=A0 =C2=A0 | f
subconninfo =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | host=3Dxyz port=3D5432 user=3Dpostgres password=3Dtest = dbname=3Dtest_v
subslotname =C2=A0 =C2=A0 =C2=A0 =C2=A0 | test_v_sub
= subsynccommit =C2=A0 =C2=A0 =C2=A0 | off
subpublications =C2=A0 =C2=A0 |= {test_v_pub}
suborigin =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | any<= br>
2) Are you trying to replicate everything at once or a table or s= ubset
of tables at a time?

We are replicating all tabl= es at once (full database-level replication), not table-by-table.

3) How active is the source database?
The source database is highly= active, with continuous transactions and heavy write activity across large= tables.


Thanks &= Regards
Krishna.


On Thu, 6 Nov 2025 at 23:53, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 11/6/25 09:04, Bala M wrote:=
>
> Hi=C2=A0 Adrian, Thank you for your response. Please find the requeste= d
> details below:
>

>=C2=A0 =C2=A0 =C2=A0Since you have already started is that not already = to late for this?
>
> Yes We are currently in the *testing phase* and validating with the > above parameters. However, the replication process has been *extremely=
> slow =E2=80=94 it=E2=80=99s been running for the past 5 days* with lim= ited progress.

1) Show how you have set up the publishers and subscribers.

2) Are you trying to replicate everything at once or a table or subset
of tables at a time?

3) How active is the source database?

>
> Any specific tuning recommendations or best practices to improve
> performance at this stage would be greatly appreciated.
>
>
> Thanks & Regards
> Krishna.
>
>

--
Adrian Klaver
adrian.klave= r@aklaver.com
--00000000000072ce9c0642f64aac--