[PERFORM] UPDATE on NOT JOIN

2012-02-15 Thread Gabriel Biberian
) 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

[PERFORM] slow update on 1M rows (worse with indexes)

2007-02-22 Thread Gabriel Biberian
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