Re: Could synchronous streaming replication really degrade the performance of the primary? - Mailing list pgsql-performance

From MauMau
Subject Re: Could synchronous streaming replication really degrade the performance of the primary?
Date
Msg-id 1407064E745B400CA15906EB79B30A78@maumau
Whole thread Raw
In response to Re: Could synchronous streaming replication really degrade the performance of the primary?  (Fujii Masao <masao.fujii@gmail.com>)
List 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 by date:

Previous
From: Robert Klemme
Date:
Subject: Re: Maximum number of sequences that can be created
Next
From: Jessica Richard
Date:
Subject: ...