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