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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



From: "Fujii Masao" <masao.fujii@xxxxxxxxx>
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


--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux