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”)

Reply via email to