Re: logical Replication

["Anjul Tyagi" <anjul@xxxxxxxxxxxxxxxx>]

Liu,

I believe they have restriction for large object like BLOB. When i read the other details, there are no limitation for large amount of data.

 
  

 

 

Regards,

Anjul TYAGI

 

ü Go Green

------ Original Message ------

From: "Liu Huarong" <liuhuarongynu@xxxxxxxxx>

To: anjul@xxxxxxxxxxxxxxxx

Cc: pgsql-admin@xxxxxxxxxxxxxx

Sent: 06-07-2018 13:02:09

Subject: Re: logical Replication

Have you checked these restrictions?

https://www.postgresql.org/docs/10/static/logical-replication-restrictions.html

Anjul Tyagi <anjul@xxxxxxxxxxxxxxxx> 于2018年7月6日周五 下午3:11写道：

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