Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CC583B5DBC9 for ; Fri, 24 Jun 2011 13:49:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 37593-06 for ; Fri, 24 Jun 2011 16:49:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from server515.appriver.com (server515d.exghost.com [72.32.253.78]) by mail.postgresql.org (Postfix) with ESMTP id A378EB5D803 for ; Fri, 24 Jun 2011 13:49:53 -0300 (ADT) X-Note-AR-ScanTimeLocal: 6/24/2011 11:48:11 AM X-Policy: GLOBAL - riskcontrollimited.com 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 277693221; Fri, 24 Jun 2011 11:48:11 -0500 Received: from FE11.exchange.rackspace.com ([192.168.1.63]) by FE1.exchange.rackspace.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 24 Jun 2011 11:49:52 -0500 Received: from [192.168.20.134] ([87.194.70.108]) by FE11.exchange.rackspace.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 24 Jun 2011 11:49:52 -0500 Message-ID: <4E04C033.8060305@riskcontrollimited.com> Date: Fri, 24 Jun 2011 17:49:55 +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: Kevin Grittner CC: Claudio Freire , pgsql-performance@postgresql.org Subject: Re: Long Running Update References: <4E035649.20007@riskcontrollimited.com> <4E0472AB.9090507@riskcontrollimited.com> <4E0462FA020000250003EBB8@gw.wicourts.gov> <4E04BB75.4070403@riskcontrollimited.com> <4E0477F2020000250003EBCA@gw.wicourts.gov> In-Reply-To: <4E0477F2020000250003EBCA@gw.wicourts.gov> X-TagToolbar-Keys: D20110624174955066 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 24 Jun 2011 16:49:52.0256 (UTC) FILETIME=[BCE1C800:01CC328E] 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/236 X-Sequence-Number: 44169 I called VACUUM on the database after abandoning the original all-in-one update. And I have a daily cron script that executes the following statement: sudo -u postgres /usr/bin/vacuumdb -U postgres --all --analyze But I had not considered using CLUSTER - I will certainly look into that. Thanks again. Harry Mantheakis London, UK