Re: [ADMIN] Replication slots and isolation levels

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [ADMIN] Replication slots and isolation levels
Дата
Msg-id CA+TgmoYn=Myxu9QHBHzwZmQtsHn=GYCix6O+LNyHxQrgP86T8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
Ответы Re: [ADMIN] Replication slots and isolation levels  (Vladimir Borodin <root@simply.name>)
Список 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 по дате отправления:

Предыдущее
От: Zeus Kronion
Дата:
Сообщение: Re: WIP: Fix parallel workers connection bug in pg_dump (Bug #13727)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.