From: | Renzo Kottmann <renzo(at)tzi(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange delete behaviour |
Date: | 2005-08-01 11:57:32 |
Message-ID: | 42EE0E2C.5080700@tzi.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a strange delete behaviour in my postgres 8.0.3 database:
If I try a
delete
from t_node
where node_doc_id = XX;
from inside a plpgsql function
on this table:
CREATE TABLE t_node (
node_global_id int4 DEFAULT nextval('seq_node') NOT NULL ,
node_doc_id int4 NOT NULL ,
node_local_id int4 NOT NULL ,
node_offset int4 NOT NULL ,
FOREIGN KEY ( node_doc_id )
REFERENCES t_document ( doc_id )
MATCH FULL ,
PRIMARY KEY ( node_global_id )
);
CREATE UNIQUE INDEX idx_node ON t_node (
node_doc_id
node_local_id
);
The deletion does not finish after several minutes and the CPU is
running at 100% all the time unless I stop postmaster. A select works
normal and gives me around 2500 rows. Does anybody has an idea why this
happens?
Thanks,
renzo
From | Date | Subject | |
---|---|---|---|
Next Message | Gnanavel S | 2005-08-01 12:34:52 | Re: Strange delete behaviour |
Previous Message | Robert Bernier | 2005-08-01 11:28:41 | Re: New MySQL to PostgreSQL Migration Guide |