Re: Serialization questions

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Serialization questions
Дата
Msg-id CAN_9JTw7YiFSMq_xD1bZpa=fFvKP_avzavpt0J5ondUhVq6cCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Serialization questions  (Alex <zhihui.fan1213@gmail.com>)
Список pgsql-hackers

On Wed, Aug 21, 2019 at 9:30 AM Alex <zhihui.fan1213@gmail.com> wrote:

first issue "set default_transaction_isolation to 'serializable';" on the both sessions,  then run:

Session 1:   begin;  select * from t;  (2 rows selected);
Session 2:   delete from t;   (committed automatically)
Session 1:  commit;  (commit successfully). 

looks the reads in session 1 has no impact on the session 2 at all which is conflicted with the document  


This behavior makes sense to me. The effect can be considered as we
 execute the two sessions in a serial order of first session 1 and then
 session 2.

Thanks
Richard

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Add "password_protocol" connection parameter to libpq
Следующее
От: Robert Haas
Дата:
Сообщение: Re: POC: Cleaning up orphaned files using undo logs