X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 66118D1B441 for ; Mon, 5 Apr 2004 18:10:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83270-10 for ; Mon, 5 Apr 2004 15:10:54 -0300 (ADT) Received: from mail.ez3pl.com (66-136-75-131.ded.swbell.net [66.136.75.131]) by svr1.postgresql.org (Postfix) with ESMTP id DB169D1B54E for ; Mon, 5 Apr 2004 15:10:21 -0300 (ADT) Received: from kbarnard ([172.25.96.149]) by mail.ez3pl.com (8.11.2/8.11.2) with ESMTP id i35I9sL20799 for ; Mon, 5 Apr 2004 13:09:54 -0500 From: "Kevin Barnard" To: Date: Mon, 05 Apr 2004 13:04:52 -0500 MIME-Version: 1.0 Subject: Re: atrocious update performance Message-ID: <40715974.10626.ED9A003@localhost> In-reply-to: <009801c41b30$37872380$2500fa0a@CardServices.TCI.com> References: <004301c411be$74004650$2500fa0a@CardServices.TCI.com> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/49 X-Sequence-Number: 6349 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. Kevin Barnard SpeedFC