Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fbKu6-0002i0-Ic for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jul 2018 07:11:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fbKu3-0001hd-Tr for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jul 2018 07:11:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fbKu3-0001hU-6D for pgsql-admin@lists.postgresql.org; Fri, 06 Jul 2018 07:11:39 +0000 Received: from himalaya.serversfarm.com ([173.254.202.145] helo=rio.serversfarm.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fbKtz-0000Zh-Br for pgsql-admin@postgresql.org; Fri, 06 Jul 2018 07:11:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ibosstech-us.com; s=default; h=Content-Type:Mime-Version:Reply-To: Message-Id:Date:Subject:To:From:Sender:Cc:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:In-Reply-To:References:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=HfUVA6x/xA5o+PLFrVJ3PdF9DJF8dzeU+0vNCE9wbxQ=; b=pfJuc0X4deZ0tp0OskqNeS/sc gUn0jw3Wx7dadZ6J7kwGLyw8u5ECiiRMHjDnxhfqF1IbZeMlhLKxGTLZekD/PJa04IpjTUfAz/eFd HzQtFFSa0Q3OqLBZiDJJ6U51uPawO0oTslvcJ337wr5ueNkbNPRvEFNLLyNi6z+uN3cbsGeRlgywx Fh+63uoIQ2pKkx8Z95YNH5GfRE+huQ5AOAOGIbSQLEnrHX8QlMbvas3we9yw77bsspQ0JetZsdyW6 B1JytrqPKEnhb4fXbHknzVxjpwVaSs3Ia5062Ujw95Z4LPLYqarNg5z7RwOkF2EGrq3M2Px0cPRwR +wda1fT3A==; Received: from [111.93.60.54] (port=65288 helo=[192.168.3.137]) by rio.serversfarm.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.91) (envelope-from ) id 1fbKtv-00C50m-Oh for pgsql-admin@postgresql.org; Fri, 06 Jul 2018 03:11:32 -0400 From: "Anjul Tyagi" To: "pgsql-admin@postgresql.org" Subject: logical Replication Date: Fri, 06 Jul 2018 07:11:28 +0000 Message-Id: Reply-To: "Anjul Tyagi" User-Agent: eM_Client/7.1.31849.0 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------=_MB9EB0AE67-96C5-4AD8-8107-EB8FF5D382A9" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - rio.serversfarm.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - ibosstech-us.com X-Get-Message-Sender-Via: rio.serversfarm.com: authenticated_id: anjul@ibosstech-us.com X-Authenticated-Sender: rio.serversfarm.com: anjul@ibosstech-us.com X-Source: X-Source-Args: X-Source-Dir: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --------=_MB9EB0AE67-96C5-4AD8-8107-EB8FF5D382A9 Content-Type: text/plain; format=flowed; charset=utf-8 Content-Transfer-Encoding: quoted-printable Team, we are trying to setup an logical replication on the Postgres 10.4, we=20 are able to replicate the small tables but facing issue with big tables,=20 when table has around 60 columns and 30 million rows. While checking the log on publication server, it shows copy command but=20 did not copy data to subscriber server. Postgres Version - 10.4 Linux - SUSE SLE-12.3 Following are the setting we have enabled on Primary server: Primary Server: wal_level =3D logical shared_buffers =3D 6GB effective_cache_size =3D 18GB maintenance_work_mem =3D 1536MB checkpoint_completion_target =3D 0.9 wal_buffers =3D 16MB default_statistics_target =3D 100 random_page_cost =3D 1.1 effective_io_concurrency =3D 200 work_mem =3D 3145kB min_wal_size =3D 1GB max_wal_size =3D 2GB max_replication_slots =3D 25 max_wal_senders =3D 30 max_parallel_workers_per_gather =3D 2 max_parallel_workers =3D 4 Secondary Server: shared_buffers =3D 6GB effective_cache_size =3D 18GB maintenance_work_mem =3D 1536MB checkpoint_completion_target =3D 0.9 wal_buffers =3D 16MB default_statistics_target =3D 100 random_page_cost =3D 1.1 effective_io_concurrency =3D 200 work_mem =3D 3145kB max_replication_slots =3D 25 max_logical_replication_workers =3D 30 max_worker_processes =3D 31 can you please help us to understand, if is there any issue on the=20 configuration. Regards, Anjul TYAGI =C3=BC Go Green --------=_MB9EB0AE67-96C5-4AD8-8107-EB8FF5D382A9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Team,

we are trying to setup an logic= al replication on the Postgres 10.4, we are able to replicate the small tab= les but facing issue with big tables, when table has around 60 columns and= 30 million rows.=C2=A0

While checking the log on = publication server, it shows copy command but did not copy data to subscri= ber server.=C2=A0

Postgres Version - 10.4
<= div>Linux - SUSE SLE-12.3

Following are the sett= ing we have enabled on Primary server:

Primar= y Server:
wal_level =3D logical
shared_buffers =3D= 6GB
effective_cache_size =3D 18GB
maintenance_work_mem = =3D 1536MB
checkpoint_completion_target =3D 0.9
wal_bu= ffers =3D 16MB
default_statistics_target =3D 100
random= _page_cost =3D 1.1
effective_io_concurrency =3D 200
wor= k_mem =3D 3145kB
min_wal_size =3D 1GB
max_wal_size =3D= 2GB
max_replication_slots =3D 25
max_wal_senders =3D 30
max_parallel_workers_= per_gather =3D 2
max_parallel_workers =3D 4

=
Secondary Server:
shared_buffers =3D 6GB
effective_cach= e_size =3D 18GB
maintenance_work_mem =3D 1536MB
checkpo= int_completion_target =3D 0.9
wal_buffers =3D 16MB
defa= ult_statistics_target =3D 100
random_page_cost =3D 1.1
= effective_io_concurrency =3D 200
work_mem =3D 3145kB
ma= x_replication_slots =3D 25=C2=A0
max_logical_replication_workers = =3D 30
max_worker_processes =3D 31

ca= n you please help us to understand, if is there any issue on the configurat= ion.
=C2=A0
=C2=A0

Regards,

Anjul TYAGI

=C2=A0

=C3=BC<= /b>=C2=A0Go=C2= =A0Green


--------=_MB9EB0AE67-96C5-4AD8-8107-EB8FF5D382A9--