From: Anjul Tyagi <anjul@ibosstech-us.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: logical Replication
Date: Mon, 09 Jul 2018 07:03:18 +0000
Message-ID: <em58730ba1-a0a7-4e63-a20d-ae8bd3076716@iboss01081> (raw)
In-Reply-To: <CAGDYbUNCC+7rUw_P_xmjgYFpQdaZ6LsjxkzkvNYgV4oRAfMVwg@mail.gmail.com>
References: <emb84ebd01-d8b2-403e-b8ff-861bedd4b18d@iboss01081>
<CAGDYbUNCC+7rUw_P_xmjgYFpQdaZ6LsjxkzkvNYgV4oRAfMVwg@mail.gmail.com>
Shreeyansh,
Yes.. we have same structure in the subscription side as well.
Regards,
Anjul TYAGI
ü Go Green
------ Original Message ------
From: "Shreeyansh Dba" <shreeyansh2014@gmail.com>
To: "Anjul Tyagi" <anjul@ibosstech-us.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Sent: 06-07-2018 21:02:33
Subject: 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@ibosstech-us.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
>>
>>
>
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, shreeyansh2014@gmail.com
Subject: Re: logical Replication
In-Reply-To: <em58730ba1-a0a7-4e63-a20d-ae8bd3076716@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