Dirk Mika schrieb am 01.07.2019 um 13:18: > The problem with the INSERT ON CONFLICT is that an insert is tried here first, which may fire triggers. > > In my case there is a fairly expensive INSERT Trigger ON EACH ROW, which I would like to avoid. The insert trigger will only be fired if an INSERT actually takes place. If INSERT ON CONFLICT results in an UPDATE (or a DO NOTHING), no INSERT trigger will be fired.
