"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?


Reply via email to