On Sat, Jan 21, 2012 at 3:31 AM, Jerry Richards
<jerry(dot)richards(at)teotech(dot)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(at)stuartbishop(dot)net>
http://www.stuartbishop.net/