Re: Could synchronous streaming replication really degrade the performance of the primary?

Поиск
Список
Период
Сортировка
От MauMau
Тема Re: Could synchronous streaming replication really degrade the performance of the primary?
Дата
Msg-id 1407064E745B400CA15906EB79B30A78@maumau
обсуждение исходный текст
Ответ на Re: Could synchronous streaming replication really degrade the performance of the primary?  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-performance
From: "Fujii Masao" <masao.fujii@gmail.com>
> Though I cannot show the detail for some reasons, as far as I measured
> the performance overhead of sync rep by using pgbench, the overhead of
> throughput was less than 10%. When measuring sync rep, I used two
> set of physical machine and storage for the master and standby, and
> used 1Gbps network between them.

Fujii-san, thanks a million. That's valuable information. The overhead less
than 10% under perhaps high concurrency and write heavy workload exceeds my
expectation. Great!

Though I couldn't contact the testers today, I'll tell this to them next
week.

Regards
MauMau


В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Klemme
Дата:
Сообщение: Re: Maximum number of sequences that can be created
Следующее
От: Jessica Richard
Дата:
Сообщение: ...