From: Anjul Tyagi <anjul@ibosstech-us.com>
To: pgsql-admin@postgresql.org
Subject: Re: logical Replication
Date: Fri, 06 Jul 2018 14:40:05 +0000
Message-ID: <emedfd9837-e4a5-41f4-a107-14e36e042673@iboss01081> (raw)
In-Reply-To: <CAPNuM3tWBa0SdrRr_TymksWMXKa9VNn3-zsisCi6fW6f5eiSCg@mail.gmail.com>
References: <emb84ebd01-d8b2-403e-b8ff-861bedd4b18d@iboss01081>
<CAPNuM3tWBa0SdrRr_TymksWMXKa9VNn3-zsisCi6fW6f5eiSCg@mail.gmail.com>
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@gmail.com>
To: anjul@ibosstech-us.com
Cc: pgsql-admin@postgresql.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@ibosstech-us.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
>>
>>
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: <emedfd9837-e4a5-41f4-a107-14e36e042673@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