High level Postgres launched INSERT / UPDATE speed?

Question

I know that when I UPDATEline in Pg, this line is overwritten, and the old line is deactivated when a new line is activated. I know that this is due to how the MVCC level is implemented.

What are the advantages then UPDATEover DELETE ... INSERT? Is there something else in relation to the relationship UPDATEand DELETEin Postgresql? I can not find any documents that talk about this or about mailing lists. Obviously, they fire different user triggers, if any, but what happens under the hood to give them different performance profiles?

Answer 1

DELETE , . .

FILLFACTOR, HOT update. , . HOT () .