Re: How do concurrent inserts work?

From: Yaroslav <ladayaroslav(at)yandex(dot)ru>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do concurrent inserts work?
Date: 2014-12-27 12:19:18
Message-ID: 1419682758777-5832163.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G Johnston 2014-12-27 16:08:12 Re: How do concurrent inserts work?
Previous Message Serge Fonville 2014-12-27 12:15:46 Re: How do concurrent inserts work?