PostgreSQL UPSERT with CTE Cuts 100k Email Update from 90s to 5s

A developer optimized a PostgreSQL batch UPSERT with history tracking using a Common Table Expression (CTE), reducing execution time from 90 seconds to 5 seconds for 100k email records. The approach updates email states and records audit history in a single query. The technique leverages CTE for efficient bulk operations.