PostgreSQL 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20060104 (prerelease) (Debian 4.0.2-6)
Michael Fuhr wrote:
> 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;
>
>
--
*Jamie Deppeler
*Database Administrator
*once:technologies pty ltd
*
*Do It Once!*
46 Roseneath Street
North Geelong
Victoria 3215 Australia
Ph: +61 3 5278 6699
Fax: +61 3 5278 6166
Email: jamie@doitonce.net.au
Web: http://www.oncefabrik.com <http://www.oncefabrik.com/>