Re: Synchronous Log Shipping Replication

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Synchronous Log Shipping Replication
Дата
Msg-id 3f0b79eb0809080654g4d0c63c3o1993cec74ffb2016@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Synchronous Log Shipping Replication  (Markus Wanner <markus@bluegap.ch>)
Ответы Re: Synchronous Log Shipping Replication
Re: Synchronous Log Shipping Replication
Список 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 по дате отправления:

Предыдущее
От: tomas@tuxteam.de
Дата:
Сообщение: Re: [PATCH] Cleanup of GUC units code
Следующее
От: Tom Lane
Дата:
Сообщение: Re: reducing statistics write overhead