"Andrus" <eetasoft@xxxxxxxxx> writes: > UPDATE firma1.rid SET toode=NULL > WHERE toode IS NOT NULL AND > toode NOT IN (SELECT TOODE FROM firma1.TOODE); > How to speed this up ? Increasing work_mem to the point where you get a hashed NOT-IN would help, probably. Have you tried using EXPLAIN to see what the plan is for the UPDATEs? regards, tom lane
