Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Replication slots and isolation levels - Mailing list pgsql-admin

From Michael Paquier
Subject Re: [HACKERS] Replication slots and isolation levels
Date
Msg-id CAB7nPqTW_v4odZrRX7vYtf5OWVBwzK=oDffwikgrOunQFsa8JA@mail.gmail.com
Whole thread Raw
In response to Re: Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
Responses Re: [HACKERS] Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Vladimir Borodin
Date:
Subject: Re: Replication slots and isolation levels
Next
From: Vladimir Borodin
Date:
Subject: Re: [HACKERS] Replication slots and isolation levels