Postgres Pro
Downloads
Home   >   mailing lists

Re: How do concurrent inserts work? - Mailing list pgsql-novice

From Serge Fonville
Subject Re: How do concurrent inserts work?
Date
Msg-id CAOAS_+LMUJX+miecOgL_YjSfjQZ3hTQ9zZQRLjAjfNQppDnXrQ@mail.gmail.com
Whole thread Raw
In response to Re: How do concurrent inserts work?  (Yaroslav <ladayaroslav@yandex.ru>)
Responses Re: How do concurrent inserts work?  (Serge Fonville <serge.fonville@gmail.com>)
Re: How do concurrent inserts work?  (Yaroslav <ladayaroslav@yandex.ru>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Yaroslav
Date:
Subject: Re: How do concurrent inserts work?
Next
From: Serge Fonville
Date:
Subject: Re: How do concurrent inserts work?