Re: logical Replication

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(at)gmail(dot)com>
To: anjul(at)ibosstech-us(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
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(at)ibosstech-us(dot)com> 于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
>>
>>