| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Vladimir Borodin <root(at)simply(dot)name> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Oleksii Kliukin <alexk(at)hintbits(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [ADMIN] Replication slots and isolation levels |
| Date: | 2015-10-30 12:42:19 |
| Message-ID: | CAB7nPqT1kGYHUomtJivC95EDsL6OQWcy2+76DnG5Y2Cj1DdYTg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
On Fri, Oct 30, 2015 at 12:40 PM, Vladimir Borodin wrote:
> On Thu, Oct 29, 2015 at 3:29 PM, Oleksii Kliukin wrote:
>> Could it be a consequence of how REPEATABLE READ transactions handle
>> snapshots? With REPEATABLE READ the snapshot is acquired only once at the
>> beginning of a transaction; a READ COMMITTED transaction re-evaluates its
>> snapshot with each new command.
>
> 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 COMMITTED (which is the default) you may still get conflicts with
> recovery while using replication slots?
Replication slots and hot_standby_feedback are two different unrelated
concepts, slots being aimed at retaining WAL. I guess that's the
origin of your confusion:
http://www.postgresql.org/message-id/20150616192141.GD2626@alap3.anarazel.de
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-10-30 12:59:59 | Re: [ADMIN] Replication slots and isolation levels |
| Previous Message | Vladimir Borodin | 2015-10-30 11:40:23 | Re: [HACKERS] Replication slots and isolation levels |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-10-30 12:59:59 | Re: [ADMIN] Replication slots and isolation levels |
| Previous Message | Oleksandr Shulgin | 2015-10-30 11:50:00 | Re: Replication connection URI? |