Re: atrocious update performance - Mailing list pgsql-performance

From Richard Huxton
Subject Re: atrocious update performance
Date
Msg-id 200403170911.37462.dev@archonet.com
Whole thread Raw
In response to Re: atrocious update performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: atrocious update performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-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

pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: A good article about application tuning
Next
From: Tom Lane
Date:
Subject: Re: atrocious update performance