"D'Arcy J.M. Cain" <darcy(at)druid(dot)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
In response to
pgsql-performance by date
|Next:||From: Sean Shanny||Date: 2003-12-29 16:35:43|
|Subject: Question about difference in performance of 2 queries on large table|
|Previous:||From: D'Arcy J.M. Cain||Date: 2003-12-27 10:52:07|
|Subject: Re: What's faster?|