[GENERAL] Very slow table

[Richard Weiss]

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.