Re: atrocious update performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: atrocious update performance
Date
Msg-id 25016.1079536599@sss.pgh.pa.us
Whole thread Raw
In response to Re: atrocious update performance  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Richard Huxton <dev@archonet.com> writes:
> Two questions Tom:
> 1. Do the stats tables record FK checks, or just explicit table accesses?

The stats record everything, IIRC.

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

That's quite a good thought, though since Rosser's system is live it
might be hard to get a view of just one query's activity.

            regards, tom lane

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: atrocious update performance
Next
From: "Arthur Ward"
Date:
Subject: Re: rapid degradation after postmaster restart