Re: Query runs too long for indexed tables - Mailing list pgsql-performance

"Andrus" <eetasoft@online.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