Re: Retrieve the snapshot's LSN

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Retrieve the snapshot's LSN
Дата
Msg-id CA+Tgmoa286s8VrmoODaxPZRaTjXonKrd_tAouHqO4+LykcBe=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Retrieve the snapshot's LSN  (Andres Freund <andres@anarazel.de>)
Ответы Re: Retrieve the snapshot's LSN  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Thu, Jul 16, 2015 at 12:54 PM, Andres Freund <andres@anarazel.de> wrote:
> Well, in combination with logical decoding it kinda has one: It should
> allow you to take a dump of the database with a certain snapshot and
> replay all transactions with a commit lsn bigger than the "snapshot's
> lsn" and end up with a continually consistent database.
>
> Visibility for HS actually works precisely in commit LSN order, even if
> that is possibly different than on the primary...

That makes sense, and hopefully answers Florent's question about why
this is only exposed through the slot mechanism.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Support for N synchronous standby servers - take 2