Re: Synchronous Log Shipping Replication - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Synchronous Log Shipping Replication
Date
Msg-id 3f0b79eb0809080654g4d0c63c3o1993cec74ffb2016@mail.gmail.com
Whole thread Raw
In response to Re: Synchronous Log Shipping Replication  (Markus Wanner <markus@bluegap.ch>)
Responses Re: Synchronous Log Shipping Replication  (Markus Wanner <markus@bluegap.ch>)
Re: Synchronous Log Shipping Replication  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Mon, Sep 8, 2008 at 8:44 PM, Markus Wanner <markus@bluegap.ch> wrote:
>>        Merge into WAL writer?
>
> Uh.. that would mean you'd loose parallelism between WAL writing to disk and
> WAL shipping via network. That does not sound appealing to me.

That depends on the order of WAL writing and WAL shipping.
How about the following order?

1. A backend writes WAL to disk.
2. The backend wakes up WAL sender process and sleeps.
3. WAL sender process does WAL shipping and wakes up the backend.
4. The backend issues sync command.

>> I guess we could invent a new semaphore-like primitive at the same layer
>> as LWLocks using spinlock and PGPROC directly...
>
> Sure, but in what way would that differ from what I do with imessages?

Performance ;)

The timing of the process's receiving a signal is dependent on the scheduler
of kernel. The scheduler does not always handle a signal immediately.

Regards

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: [PATCH] Cleanup of GUC units code
Next
From: Tom Lane
Date:
Subject: Re: reducing statistics write overhead