On 01/20/12 12:31 PM, Jerry Richards 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.
when a client issues a COMMIT on the master, synchronous by definition has to wait for the replication to be committed on the slave. this will of course be slower, how much slower depends on far too many variables to give an estimate, including things like speed of both servers disk systems, speed of the network communications, data volume and transaction rate.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
