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?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services