Re: [HACKERS] Replication slots and isolation levels

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [HACKERS] Replication slots and isolation levels
Дата
Msg-id CAB7nPqTW_v4odZrRX7vYtf5OWVBwzK=oDffwikgrOunQFsa8JA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
Ответы Re: [HACKERS] Replication slots and isolation levels
Список pgsql-admin
On Thu, Oct 29, 2015 at 9:42 AM, Vladimir Borodin wrote:
> I’m wondering why do I get conflicts with recovery on hot standby using
> replication slots and read commited isolation level? And if I start
> repeatable read transaction I don’t get any errors. Below is some
> diagnostics.

In the case of repeatable read the standby will wait before applying
the VACUUM WAL record cleaning up a relation page. Hence you won't get
conflicts in this case.
--
Michael


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

Предыдущее
От: Vladimir Borodin
Дата:
Сообщение: Re: Replication slots and isolation levels
Следующее
От: Vladimir Borodin
Дата:
Сообщение: Re: [HACKERS] Replication slots and isolation levels