Very slow table

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.

Responses

Browse pgsql-general by date

  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?