) IS NULL))
SubPlan
-> Limit (cost=0.00..9.53 rows=1 width=0)
-> Index Scan using temporary_hash on temporary t
(cost=0.00..9.53 rows=1 width=0)
Index Cond: (hash = $0)
(6 lignes)
Is there a better way to update a table if it doesn't join another tab
m25.274s (+321M)
As a sanity check, i loaded mysql5 and tried the same database and
updates. With mysql, the update always lasts ~8s.
The conclusions I have come to is that update==insert+delete which seems
very heavy when index are present (and heavy disk wise on big tables).
Is there a switch i