"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> We went through this recently. One thing we found that may apply to you is
> how many fields in the client record have a foreign key constraint. We find
> that tables with lots of FKeys are a lot more intensive on updates.
BTW, this should have gotten better in 7.3.4 and later --- there is
logic to skip checking an FKey reference if the referencing columns
didn't change during the update.
regards, tom lane