5 ms·

So to simplify, what I understand is 1. INSERT .. ON CONFLICT is an implementation UPSERT technique 2. MERGE is something meant to be different from UPSERT bu

So to simplify, what I understand is 1. INSERT .. ON CONFLICT is an implementation UPSERT technique 2. MERGE is something meant to be different from UPSERT but has UPSERT feature?

jeltz 11y ago
Basically true except for many implementations of MERGE not being concurrency safe, which means you would have to loop anyway on unique violation making it no better than the CTE based techniques that already exist in 9.4.