Re: Avoid full page images in streaming replication?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Avoid full page images in streaming replication?
Дата
Msg-id 51417.1445549918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Avoid full page images in streaming replication?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: Avoid full page images in streaming replication?  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> ISTM it should be possible to avoid sending full page writes to a 
> streaming replica once the replica has reached a consistent state. I 
> assume that the replica would still need to write full pages to it's 
> disk in case of a crash, but the sender could insert special WAL records 
> to tell it when to do so, instead of sending the full page image. 
> Presumably this would be a big win for replication over a WAN.

How are you going to make that work without LSNs in the WAL received by
the replica diverging from those in the master's WAL?
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Making tab-complete.c easier to maintain
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Avoid full page images in streaming replication?