[tommoor]

I might get some hate, but I also think upsert was one of the best features that MongoDB offered that PG didn't, so this is a big win from that perspective too.

[bpicolo]

Which makes sense, because the atomicity of the upsert is really the tricky part.

[JohnBooty]

Not at all. UPSERT is the feature everybody's excited about!