PostgreSQL UPSERT with History: From 90 Seconds to 5 with CTE

Hi, a couple of years ago I wrote about batch insert and update in PostgreSQL using UNNEST — it's worth expanding on this topic by using a CTE, based on a real-world task. 100k emails with an audit lo