"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
