Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Jerry Richards <jerry(dot)richards(at)teotech(dot)com>
Cc: John R Pierce <pierce(at)hogranch(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-20 22:10:36
Message-ID: CAEYLb_VMjKKMYpd28cAhpqLxFZ2MRJFRcgrx7pRtNjHX0LwgCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 20 January 2012 21:53, Jerry Richards <jerry(dot)richards(at)teotech(dot)com> wrote:
> I noticed there are several synchronous implementations (Postgre-XC, PGCluster, pgpool, rubyrep, built-in streaming, etc.).  When you say, " you can dynamically change that right down to the transaction level...", are you referring specifically to one of these implementations?

I refer specifically to the synchronous replication feature that was
introduced into PostgreSQL itself, in the current 9.1 release:

http://www.postgresql.org/docs/9.1/static/warm-standby.html#SYNCHRONOUS-REPLICATION

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-01-20 22:54:49 Re: Adding German Character Set to PostgresSQL
Previous Message G_Hosa_Phat 2012-01-20 21:58:29 Re: "could not accept SSPI security context"