Re: [HACKERS] Logical replication existing data copy

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема Re: [HACKERS] Logical replication existing data copy
Дата
Msg-id f62efd9212969366d455d4dccd342669@xs4all.nl
обсуждение исходный текст
Ответ на [HACKERS] Logical replication existing data copy  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Ответы Re: Logical replication existing data copy  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Rafia Sabih
Дата:
Сообщение: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)