From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | David Griffiths <dgriffiths(at)boats(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Another weird one with an UPDATE |
Date: | 2003-10-13 15:04:27 |
Message-ID: | 3F8ABEFB.4010107@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
David Griffiths wrote:
> Yes, the query operates only on indexed columns (all numeric(10)'s).
>
> Column | Type |
> Modifiers
> -------------------------------+-----------------------------+--------------
> ---------------
> user_account_id | numeric(10,0) | not null
> [snip]
> Indexes: user_account_pkey primary key btree (user_account_id),
> Foreign Key constraints: $1 FOREIGN KEY (lang_id) REFERENCES lang(lang_id)
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> $2 FOREIGN KEY (source_id) REFERENCES
> source(source_id) ON UPDATE NO ACTION ON DELETE NO ACTION,
> $3 FOREIGN KEY (user_role_id) REFERENCES
> user_role(user_role_id) ON UPDATE NO ACTION ON DELETE NO ACTION
And what about commercial_entity.user_account_id. Is it indexed and what
is its data type (i.e. does it match numeric(10,0))?
Also, have you run VACUUM ANALYZE lately?
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2003-10-13 15:37:53 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
Previous Message | ingrim | 2003-10-13 14:38:25 | unsuscribe mailing list |