Re: Please help to speed up UPDATE statement

On Apr 12, 2005 9:40 AM, Andrus <noeetasoftspam(at)online(dot)ee> wrote:
>
> The following statement runs VERY slowly on large tables.
>
> Any idea how to speed it up ?
>
> UPDATE rid SET dokumnr=NULL WHERE
> dokumnr NOT IN (SELECT dokumnr FROM dok);
>
> Tables:
>
> CREATE TABLE dok ( dokumnr INTEGER,
> CONSTRAINT dok_pkey PRIMARY KEY (dokumnr) );
>
> CREATE TABLE rid ( dokumnr INTEGER );
> CREATE INDEX rid_dokumnr_idx ON rid (dokumnr);
>
> Andrus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

Please send your explain plan everyone will want to see it to tell what is
going on.