Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> Can anyone offering suggestions as to why the UPDATE takes so long and
> what I might do to make it go faster?
I think it's the foreign keys that are hurting you. Are the referenced
columns indexed? Are they of the same datatypes as the referencing
columns? Have you ANALYZEd those tables lately?
regards, tom lane