On Thu, Jul 13, 2006 at 04:58:26PM +1000, Jamie Deppeler wrote:
> db=# \d job
> Table "job"
> Column | Type
> | Modifiers
> ---------------------+-----------------------------+----------------------------------------------------------------
> primary | integer | not null default
> nextval('job_primary_seq'::regclass)
> jobnumber | text |
> jobname | text |
> jobdetails | text |
> Indexes:
> "job_pkey" PRIMARY KEY, btree ("primary")
You said you were running 8.0 but "nextval('job_primary_seq'::regclass)"
suggests 8.1. What does "SELECT version()" show?
What are the output of the following?
EXPLAIN ANALYZE SELECT "primary" FROM job WHERE "primary" = 370;
EXPLAIN ANALYZE DELETE FROM job WHERE "primary" = 370;
If these commands use index or bitmap index scans, do you get
different results if you execute the following commands and then
try the delete again?
SET enable_indexscan TO off;
SET enable_bitmapscan TO off;
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
