| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Kevin Barnard <kbarnard(at)speedfc(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: atrocious update performance |
| Date: | 2004-04-05 22:48:49 |
| Message-ID: | Pine.LNX.4.33.0404051648240.13959-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 5 Apr 2004, Kevin Barnard wrote:
> On 5 Apr 2004 at 12:05, Rosser Schwarz wrote:
>
> > Just this morning, however, I created a copy of the target table (all
> > 4.7M rows), with absolutely no foreign keys referring to it, and ran
> > the update against the copy. That update took 2300 seconds. The
> > join columns were indexed in both cases.
>
> Have you added indexes for the custid column for tables account.acct accunt.orgacct
> and note?
>
> I haven't followed the entire thread but it you have cascading FK on those tables
> without an index on the column that could cause your delay.
also make sure the fk/pk types match, or the index likely won't get used
anyway.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-04-06 00:20:20 | Re: atrocious update performance |
| Previous Message | Matthew T. O'Connor | 2004-04-05 21:28:33 | Re: performance comparission postgresql/ms-sql server |