"Andrus" <eetasoft(at)online(dot)ee> 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