Is there any serious difference in the used disk and memory storage between upsert and delete + insert ?
e.g. 2 vs 2A + 2B. PK ((key), version, c1) 1. INSERT INTO A (key , version , c1, val) values (1, 1, 4711, “X1”) ... 2. INSERT INTO A (key , version , c1, val) values (1, 1, 4711, “X2”) Vs. 2A. DELETE FROM A WHERE key=1 AND version = 1 AND c1=4711 2B. INSERT INTO A (key , version , c1, values) values (1, 1, 4711, “X2”)