I have a question about a statement like this one: INSERT ... ON CONFLICT DO (update certain fields if they are different from stored values where id = id). If the row (identified by id) exists and the values are the same, does this query involve any disk writes? I have set a query like this one to run every 20 seconds and I am concerned about disk life expectancy because of possibly avoidable disk activity. Thank you.
So basically does UPDATE write data if it doesn’t differ? I think it does, s this question. I wouldn’t worry about disk lifetime impact of a DB query every 20 seconds though.
It updates rows identified by their ids only if the to be inserted data differ from the stored data in the DB.
My question more precisely, does an attempt to insert blocked by conflicting id, the attempt itself does it involve disk writing?
