Re: atrocious update performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: "Rosser Schwarz" <rschwarz(at)totalcardinc(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: atrocious update performance
Date: 2004-03-17 15:16:39
Message-ID: 25016.1079536599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Arthur Ward 2004-03-17 15:40:35 Re: rapid degradation after postmaster restart
Previous Message Richard Huxton 2004-03-17 09:11:37 Re: atrocious update performance