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

From Yaroslav
Subject Re: How do concurrent inserts work?
Date
Msg-id 1419682758777-5832163.post@n5.nabble.com
Whole thread Raw
In response to Re: How do concurrent inserts work?  (Serge Fonville <serge.fonville@gmail.com>)
Responses Re: How do concurrent inserts work?  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-novice
Serge Fonville wrote
> 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.

Just re-tested, and no, it doesn't wait and behaves exactly as I described.
My PostgreSQL version is:  "PostgreSQL 9.3.4, compiled by Visual C++ build
1600, 32-bit", if it's relevant.





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


pgsql-novice by date:

Previous
From: Serge Fonville
Date:
Subject: Re: How do concurrent inserts work?
Next
From: David G Johnston
Date:
Subject: Re: How do concurrent inserts work?