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.
Standby will receive but will not apply? Or master will not vacuum needed by standby pages? It seems that the second one is happening because replication lag on standby does not increase while issuing such repeatable read transaction.