On Mon, Jan 23, 2012 at 9:37 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, Jan 23, 2012 at 2:30 PM, Stuart Bishop <stuart@stuartbishop.net> wrote:
>> On Sat, Jan 21, 2012 at 3:31 AM, Jerry Richards
>> <jerry.richards@teotech.com> wrote:
>>> Is synchronous postgresql replication slower than asynchronous? If so, how
>>> much? I am looking into database replication for a phone system, so the
>>> response time is of concern.
>>
>> You might want to investigate pgpool-ii. It sits as a proxy between
>> the client and the databases, and as queries are executed
>> simultaneously, a synchronous replication setup should be just as fast
>> as an unreplicated setup.
>
> Can you share your actual results on that?
No. This is based on my assumptions from the design, not from actual
tests. I'm currently asynchronously replicated with Slony-I and
looking at PG 9.1 builtin replication for our simpler clusters.
--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/