Re: Perfornamce Q

Tom Lane wrote:
>
> I think it's the foreign keys that are hurting you.  Are the referenced
> columns indexed?

They should be, they are all primary keys in the referenced tables.

But why would they be hurting me? The update is on a column that has no
constraints on it. If the foreign key constraints are hurting me I don't
understand the reason ... could you explain why?

> Are they of the same datatypes as the referencing
> columns?

They must be no? Otherwise how could they be foreign key constraints?
(And I just checked and yes they are of the same type).

> Have you ANALYZEd those tables lately?

In the output I gave the first thing I did was a "vacuum full analyze".
I have actually found that the time require usually goes *up* strangely
enough after doing a vacuum full analyze though ...

Jc