| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
| Cc: | Jerry Richards <jerry(dot)richards(at)teotech(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is Synchronous Postgresql Replication Slower Than Asynchronous? |
| Date: | 2012-01-23 14:37:50 |
| Message-ID: | CA+U5nMJrm58G-rcfKkCrKpkHUVxmpW7d64si1_gbaGa95vVitQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 23, 2012 at 2:30 PM, Stuart Bishop <stuart(at)stuartbishop(dot)net> wrote:
> 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.
Can you share your actual results on that?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | G_Hosa_Phat | 2012-01-23 15:06:17 | Re: "could not accept SSPI security context" |
| Previous Message | Alban Hertroys | 2012-01-23 14:34:37 | Re: update with from |