Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6932CB5DBEA for ; Fri, 24 Jun 2011 08:19:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 74413-09 for ; Fri, 24 Jun 2011 11:19:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from server515.appriver.com (server515j.exghost.com [72.32.253.74]) by mail.postgresql.org (Postfix) with ESMTP id 2CF28B5D803 for ; Fri, 24 Jun 2011 08:19:07 -0300 (ADT) X-Note-AR-ScanTimeLocal: 6/24/2011 6:17:11 AM X-Policy: GLOBAL - riskcontrollimited.com X-Policy: GLOBAL - riskcontrollimited.com X-Primary: harry.mantheakis@riskcontrollimited.com X-Note: This Email was scanned by AppRiver SecureTide X-ALLOW: @riskcontrollimited.com ALLOWED X-Virus-Scan: V- X-Note: Spam Tests Failed: X-Country-Path: PRIVATE->PRIVATE->UNITED STATES->UNITED STATES X-Note-Sending-IP: 72.32.49.28 X-Note-Reverse-DNS: X-Note-WHTLIST: harry.mantheakis@riskcontrollimited.com X-Note: User Rule Hits: X-Note: Global Rule Hits: G200 G201 G202 G203 G207 G208 G219 G309 X-Note: Encrypt Rule Hits: X-Note: Mail Class: ALLOWEDSENDER X-Note: Headers Injected Received: from [72.32.49.28] (HELO FE4.exchange.rackspace.com) by server515.appriver.com (CommuniGate Pro SMTP 5.4.1c) with ESMTP id 277629217; Fri, 24 Jun 2011 06:17:11 -0500 Received: from FE4.exchange.rackspace.com ([10.244.5.57]) by FE4.exchange.rackspace.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 24 Jun 2011 06:19:06 -0500 Received: from [192.168.20.134] ([87.194.70.108]) by FE4.exchange.rackspace.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 24 Jun 2011 06:19:06 -0500 Message-ID: <4E0472AB.9090507@riskcontrollimited.com> Date: Fri, 24 Jun 2011 12:19:07 +0100 From: Harry Mantheakis User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11 MIME-Version: 1.0 To: Claudio Freire CC: pgsql-performance@postgresql.org Subject: Re: Long Running Update References: <4E035649.20007@riskcontrollimited.com> In-Reply-To: X-TagToolbar-Keys: D20110624121907877 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 24 Jun 2011 11:19:06.0684 (UTC) FILETIME=[87FFCFC0:01CC3260] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201106/223 X-Sequence-Number: 44156 Thank you Claudio. > there are lots of ways in which it could be struggling... I have been monitoring the server with IOSTAT -d and IOSTAT -c and I cannot see anything alarming. > It will be a lot faster if you can drop all indices... This is counter-intuitive - because the WHERE clause is matching the only two indexed fields, and my understanding is that querying on indexed fields is faster than querying on fields that are not indexed. (Note also, that the indexed field is NOT being updated.) But if this update fails, I shall try what you suggest! Kind regards Harry Mantheakis London, UK