Simple UPDATE runs forever

From: "Andrus Moor" <nospameetasoftnospam(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Simple UPDATE runs forever
Date: 2005-04-04 20:48:52
Message-ID: d2s9b1$1rdc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The command

UPDATE dok SET krdokumnr=NULL WHERE krdokumnr NOT in (select dokumnr from
dok);

runs forever. Postgres.exe process takes 90% of CPU time, disk LED is
flashing.
Platform: Win XP Prof SP2, Postgres 8
dok table has only 7651 rows
Killing client application does not help. Only killing postgres.exe process
stops computer activity.

CREATE TABLE ou1.dok
(
doktyyp char(1),
dokumnr numeric(12) NOT NULL DEFAULT
nextval('"ou1".dok_dokumnr_seq'::text),
krdokumnr numeric(12),
... a lot of other fields
CONSTRAINT dok_pkey PRIMARY KEY (dokumnr)
)
WITHOUT OIDS;

any idea ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-04-04 20:54:49 Re: [HACKERS] plPHP in core?
Previous Message Robert Treat 2005-04-04 20:48:50 Re: [HACKERS] plPHP in core?