How Does PostgreSQL Implement Upsert to Automatically Separate New Data from Old Data

This article explains the method that PostgreSQL uses to implement upsert for automatically separating new data from old data.

Use of the PostgreSQL Upsert (INSERT ON CONFLICT DO) Function

This article introduces a new function of PostgreSQL 9.5 called Upsert (INSERT ON CONFLICT DO).