Re: How do concurrent inserts work?

Поиск
Список
Период
Сортировка
От Serge Fonville
Тема Re: How do concurrent inserts work?
Дата
Msg-id CAOAS_+LMUJX+miecOgL_YjSfjQZ3hTQ9zZQRLjAjfNQppDnXrQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How do concurrent inserts work?  (Yaroslav <ladayaroslav@yandex.ru>)
Ответы Re: How do concurrent inserts work?  (Serge Fonville <serge.fonville@gmail.com>)
Re: How do concurrent inserts work?  (Yaroslav <ladayaroslav@yandex.ru>)
Список pgsql-novice
Дерево обсуждения
When I tested the same queries I get the same behaviour.
When both are SERIALIZABLE, the second insert just waits

When one is default (unspecified) and the other is SERIALIZABLE, the behaviour is the same as you describe.

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

2014-12-27 12:54 GMT+01:00 Yaroslav <ladayaroslav@yandex.ru>:
Serge Fonville wrote
> Perhaps because your second session doesn't specify an isolation level?

No. ;)
It's the same with any isolation level of the second session.




-----
WBR, Yaroslav Schekin.
--
View this message in context: http://postgresql.nabble.com/How-do-concurrent-inserts-work-tp5832157p5832160.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: Yaroslav
Дата:
Сообщение: Re: How do concurrent inserts work?
Следующее
От: Serge Fonville
Дата:
Сообщение: Re: How do concurrent inserts work?