Re: logical Replication

Hi Anjul,

Do you have a big table with a structure on subscription side which you are
trying to replicate?

<http://www.shreeyansh.com>

On Fri, Jul 6, 2018 at 12:41 PM, Anjul Tyagi <anjul(at)ibosstech-us(dot)com> wrote:

> 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*
>
>