Re: atrocious update performance

On Tuesday 16 March 2004 00:08, Tom Lane wrote:
>
> I'm inclined to suspect an issue with foreign-key checking.  You didn't
> give us any details about foreign key relationships your "cust" table is
> involved in --- could we see those?  And the schemas of the other tables
> involved?

Two questions Tom:
1. Do the stats tables record FK checks, or just explicit table accesses?
2. If not, should they?

If the only real activity is this update then simple before/after views of the
stats might be revealing.

--
  Richard Huxton
  Archonet Ltd