Re: Is Synchronous Postgresql Replication Slower Than Asynchronous? - Mailing list pgsql-general

From Stuart Bishop
Subject Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?
Date
Msg-id CADmi=6MKGb-UqWypUC0=0JhT2qn-7=yakjPuTA8ifA31-RjWug@mail.gmail.com
Whole thread Raw
In response to Is Synchronous Postgresql Replication Slower Than Asynchronous?  (Jerry Richards <jerry.richards@teotech.com>)
Responses Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
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.

--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: update with from
Next
From: Alban Hertroys
Date:
Subject: Re: update with from