Re: [HACKERS] Logical replication existing data copy - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: [HACKERS] Logical replication existing data copy
Date
Msg-id f62efd9212969366d455d4dccd342669@xs4all.nl
Whole thread Raw
In response to [HACKERS] Logical replication existing data copy  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: Logical replication existing data copy  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List 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.








pgsql-hackers by date:

Previous
From: Rafia Sabih
Date:
Subject: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)