"Andrus" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
