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

2012-05-11 Thread MauMau
l this to them next week. Regards MauMau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

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

2012-05-10 Thread MauMau
o is especially interesting. I'll tell my aquaintance to check it, too. Regards MauMau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

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

2012-05-10 Thread MauMau
From: "Claudio Freire" On Wed, May 9, 2012 at 7:34 PM, MauMau wrote: Yes, I understand it is natural for the response time of each transaction to double or more. But I think the throughput drop would be amortized among multiple simultaneous transactions. So, 50% throughput decr

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

2012-05-09 Thread MauMau
From: "Merlin Moncure" On Wed, May 9, 2012 at 8:06 AM, MauMau wrote: Hello, I've heard from some people that synchronous streaming replication has severe performance impact on the primary. They said that the transaction throughput of TPC-C like benchmark (perhaps DBT-2) decrea

[PERFORM] Could synchronous streaming replication really degrade the performance of the primary?

2012-05-09 Thread MauMau
ybody give me any performance evaluation result if you don't mind? Regards MauMau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance