From: | Richard Weiss <richardweiss(at)richardweiss(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Very slow table |
Date: | 2011-12-08 05:28:38 |
Message-ID: | CAB0PVev8s5-2EQstzmpvrrQc1hr7nJZ9brAq5qx5e3DqAU1vXw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, I am using squeryl, which is based on jdbc, and I am trying to run the
following statement:
delete from "Entry" where ("id" = 0)
but the query never seems to finish. I have tried it in both the program I
am writing, and the above statement in pgadmin3, and both cases never
finish.
Other queries, like
delete from "Entry" where true
complete.
The table's initialization statement is:
CREATE TABLE "Entry"
(
"pID" bigint NOT NULL,
id bigint NOT NULL,
r text NOT NULL,
CONSTRAINT "Entry_pkey" PRIMARY KEY (id),
CONSTRAINT "EntryFK21" FOREIGN KEY ("pID")
REFERENCES "PP" (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Entry" OWNER TO riri;
CREATE INDEX idx2eda05d9
ON "Entry"
USING btree
(id);
Other information:
Postgres Version: PostgreSQL 8.4.9 on i686-pc-linux-gnu, compiled by GCC
gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit
Thanks, Richard Weiss.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-12-08 05:54:25 | Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade |
Previous Message | Chris Travers | 2011-12-08 05:26:13 | Re: Hope for a new PostgreSQL era? |