High amount of disk writes during upsert with no changes on table
The DO UPDATE locks the &quot;victim&quot; tuple before it evaluates the WHERE part.  This dirties the page containing the tuple, even if the WHERE ends up short-circuiting the UPDATE.