Re:Upsert Lands in PostgreSQL 9.5 – A First Look
by ryanjshaw on Wednesday May 13, 2015 @12:50PM
(#9540229)
This implementation of upsert is especially nice because it is atomic [1]:
<literal>ON CONFLICT DO UPDATE</literal> guarantees an atomic
<command>INSERT</command> or <command>UPDATE</command> outcome - provided
there is no independent error, one of those two outcomes is guaranteed,
even under high concurrency.
I don't know about Oracle or MySQL, but the SQL Server implementation of MERGE requires you to carefully consider which locks to use and it's very easy to shoot yourself in the foot with.
[1] http://git.postgresql.org/gitweb/?p=postgresql.git;a=blobdif...