From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
Cc: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org |
Subject: | Re: Logical replication existing data copy |
Date: | 2017-03-24 10:23:59 |
Message-ID: | f62efd9212969366d455d4dccd342669@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2017-03-24 10:45, Mark Kirkwood wrote:
>
> However one minor observation - as Michael Banck noted - the elapsed
> time for slave to catch up after running:
>
> $ pgbench -c8 -T600 bench
>
> on the master was (subjectively) much longer than for physical
> streaming replication. Is this expected?
>
I think you probably want to do (on the slave) :
alter role <you role> set synchronous_commit = off;
otherwise it's indeed extremely slow.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2017-03-24 10:34:54 | Re: Patch: Write Amplification Reduction Method (WARM) |
Previous Message | Rafia Sabih | 2017-03-24 09:57:48 | Re: Enabling parallelism for queries coming from SQL or other PL functions |