Re: [ADMIN] Replication slots and isolation levels - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [ADMIN] Replication slots and isolation levels
Date
Msg-id CA+TgmoYn=Myxu9QHBHzwZmQtsHn=GYCix6O+LNyHxQrgP86T8w@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
Responses Re: [ADMIN] Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
List pgsql-hackers
On Fri, Oct 30, 2015 at 12:40 PM, Vladimir Borodin <root@simply.name> wrote:
> I still don’t fully understand why is it so (the problem occurs while
> running only one SELECT-statement in READ COMMITED so only one snapshot is
> taken), but if is expected behavior shouldn’t the documentation mention that
> using READ COMMITED (which is the default) you may still get conflicts with
> recovery while using replication slots?

Are you doing BEGIN / one or more SELECT statements / END?

Or just a bare SELECT with no explicit transaction control?

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


pgsql-hackers by date:

Previous
From: Zeus Kronion
Date:
Subject: Re: WIP: Fix parallel workers connection bug in pg_dump (Bug #13727)
Next
From: Robert Haas
Date:
Subject: Re: Patch: Implement failover on libpq connect level.