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

From: "MauMau" <maumau307(at)gmail(dot)com>
To: "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>
Cc: "Claudio Freire" <klaussfreire(at)gmail(dot)com>, "Merlin Moncure" <mmoncure(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Could synchronous streaming replication really degrade the performance of the primary?
Date: 2012-05-11 13:19:21
Message-ID: 1407064E745B400CA15906EB79B30A78@maumau
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: "Fujii Masao" <masao(dot)fujii(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jessica Richard 2012-05-12 13:01:10
Previous Message Robert Klemme 2012-05-11 10:56:30 Re: Maximum number of sequences that can be created