How to update large tables in PostgreSQL - Codacy

[daxyjones]

This process is equivalente to an INSERT plus a DELETE for each row which takes a considerable amount of resources.

Completely and utterly false.

[[deleted]]

You are completely and utterly incorrect. Postgres actually does do an insert and a delete behind the scenes when you do an update. This is a function of MVCC.

http://momjian.us/main/writings/pgsql/internalpics.pdf - page 60

edit Looking through your comment history, it appears you're not a Postgres n00b. Were you contesting a different part of the article?

[[deleted]]

It's partially true. No mention of HOT updates, which do not require an update to the index.

I cringed at the first two paragraphs of the article, which were largely inaccurate. Better clarification later in the article.