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 718E3D1D38B for ; Mon, 22 Mar 2004 14:08:31 +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 11991-03 for ; Mon, 22 Mar 2004 10:08:37 -0400 (AST) Received: from COLSWEEPER.cranel.local (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 0DAE3D1B98D for ; Mon, 22 Mar 2004 10:08:28 -0400 (AST) Received: from colmail01.cranel.local (colmail01.cranel.com) by COLSWEEPER.cranel.local (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Mon, 22 Mar 2004 09:07:57 -0500 Received: from cranel.com (192.168.11.134 [192.168.11.134]) by colmail01.cranel.local with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id HN8F5Z4R; Mon, 22 Mar 2004 09:12:48 -0500 Message-ID: <405EF35C.2080705@cranel.com> Date: Mon, 22 Mar 2004 09:08:28 -0500 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rosser Schwarz Cc: 'Tom Lane' , pgsql-performance@postgresql.org Subject: Re: atrocious update performance References: <002a01c40c45$f736d8a0$2500fa0a@CardServices.TCI.com> In-Reply-To: <002a01c40c45$f736d8a0$2500fa0a@CardServices.TCI.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/282 X-Sequence-Number: 6138 I've been following this thread closely as I have the same problem with an UPDATE. Everything is identical here right down to the strace output. Has anyone found a workaround or resolved the problem? If not, I have test systems here which I can use to help up test and explore. Greg -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@Cranel.com Cranel. Technology. Integrity. Focus.