Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5C1C1B5DBF2 for ; Fri, 24 Jun 2011 13:32:20 -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 21070-05 for ; Fri, 24 Jun 2011 16:32:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from server515.appriver.com (server515f.exghost.com [72.32.253.82]) by mail.postgresql.org (Postfix) with ESMTP id 31539B5DBEA for ; Fri, 24 Jun 2011 13:32:14 -0300 (ADT) X-Note-AR-ScanTimeLocal: 6/24/2011 11:29:25 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.5 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.5] (HELO FE1.exchange.rackspace.com) by server515.appriver.com (CommuniGate Pro SMTP 5.4.1c) with ESMTP id 279674991; Fri, 24 Jun 2011 11:29:24 -0500 Received: from FE4.exchange.rackspace.com ([192.168.1.28]) by FE1.exchange.rackspace.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 24 Jun 2011 11:31:36 -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 11:31:35 -0500 Message-ID: <4E04BBEA.3060209@riskcontrollimited.com> Date: Fri, 24 Jun 2011 17:31:38 +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: Mark Thornton CC: pgsql-performance@postgresql.org Subject: Re: Long Running Update References: <4E035649.20007@riskcontrollimited.com> <4E04889B.2030806@optrak.com> In-Reply-To: <4E04889B.2030806@optrak.com> X-TagToolbar-Keys: D20110624173138629 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 24 Jun 2011 16:31:35.0667 (UTC) FILETIME=[2F439430:01CC328C] 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/234 X-Sequence-Number: 44167 > try a series of smaller examples... Mark, that was the tip the saved me! Many thanks. Harry Mantheakis London, UK