Re: Replication

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: AgentM <agentm(at)themactionfaction(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Replication
Date: 2006-08-21 17:42:47
Message-ID: 44E9F097.6060302@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeff Davis wrote:
> How does WAL shipping help synchronous replication?

The WAL is written _before_ commit, logging all the changes the
transaction wants to write to the disk. This makes it look very similar
to what is needed for synchronous replication.

Instead of waiting for confirmation from the disk, that your WAL has
been written, you would have to wait from the network to confirm that
the changes have been delivered via the network.

Regards

Markus

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-08-21 17:45:54 Re: [HACKERS] proposal - plpgsql: execute using into
Previous Message Tom Lane 2006-08-21 17:29:48 Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to