From: Anjul Tyagi <anjul@ibosstech-us.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: logical Replication
Date: Fri, 06 Jul 2018 07:11:28 +0000
Message-ID: <emb84ebd01-d8b2-403e-b8ff-861bedd4b18d@iboss01081> (raw)
Team,
we are trying to setup an logical replication on the Postgres 10.4, we
are able to replicate the small tables but facing issue with big tables,
when table has around 60 columns and 30 million rows.
While checking the log on publication server, it shows copy command but
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 = logical
shared_buffers = 6GB
effective_cache_size = 18GB
maintenance_work_mem = 1536MB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 3145kB
min_wal_size = 1GB
max_wal_size = 2GB
max_replication_slots = 25
max_wal_senders = 30
max_parallel_workers_per_gather = 2
max_parallel_workers = 4
Secondary Server:
shared_buffers = 6GB
effective_cache_size = 18GB
maintenance_work_mem = 1536MB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 3145kB
max_replication_slots = 25
max_logical_replication_workers = 30
max_worker_processes = 31
can you please help us to understand, if is there any issue on the
configuration.
Regards,
Anjul TYAGI
ΓΌ Go Green
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: anjul@ibosstech-us.com
Subject: Re: logical Replication
In-Reply-To: <emb84ebd01-d8b2-403e-b8ff-861bedd4b18d@iboss01081>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox