Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id F09A51337B58 for ; Wed, 26 Jan 2011 19:42:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 34913-04 for ; Wed, 26 Jan 2011 23:42:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148136.authsmtp.co.uk (outmail148136.authsmtp.co.uk [62.13.148.136]) by mail.postgresql.org (Postfix) with ESMTP id D5D0E1337B64 for ; Wed, 26 Jan 2011 19:42:25 -0400 (AST) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p0QNgPA5060066; Wed, 26 Jan 2011 23:42:25 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p0QNgJps051452; Wed, 26 Jan 2011 23:42:20 GMT Message-ID: <4D40B15A.2090900@agliodbs.com> Date: Wed, 26 Jan 2011 15:42:18 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Tom Lane CC: pgsql-bugs@postgresql.org Subject: Re: Multicolun index creation never completes on 9.0.1/solaris References: <4D3F2D10.1020905@agliodbs.com> <21735.1295990515@sss.pgh.pa.us> <4D3F86D9.9080200@agliodbs.com> <14452.1296010153@sss.pgh.pa.us> <4D4069EF.6040603@agliodbs.com> <23139.1296069017@sss.pgh.pa.us> <4D40795A.8000103@agliodbs.com> <24466.1296072782@sss.pgh.pa.us> In-Reply-To: <24466.1296072782@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: eb06db8b-29a5-11e0-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1AAcB1xOVtbHwkA AnYJWF5QUldzWC1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoAX1/ UWReERl3dgFDejB0 Y0dkECUJXEIuJ04v X0xdRGgbZGY1aH0X UBJRagNUcgFMeh8X Ylh8AT1vNG8XDQgF MDQGdxUsOSleIyNR XwdFLFQeTFZDFSQx TgwDGjNnG0AbSj97 JBsjMloRAEsKekI0 eQpnARRBdAQVDgRE Hlol X-Authentic-SMTP: 61633136333939.1015:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/219 X-Sequence-Number: 29241 On 1/26/11 12:13 PM, Tom Lane wrote: > Josh Berkus writes: >> Oh! Actually, it only *did* 27 runs. So it actually completed building >> the index. I'd expected trace_sort to give me some kind of completion >> message; apologies for not checking all screen windows. > > Huh, there should be an "external sort ended" message, as well as some > other ones once it finishes writing the initial runs. Oh, fooled by log rotation: LOG: finished writing run 83 to tape 82: CPU 2600.37s/19449.04u sec elapsed 22402.36 sec LOG: finished writing run 84 to tape 83: CPU 2630.31s/19674.93u sec elapsed 22659.40 sec LOG: finished writing run 85 to tape 84: CPU 2658.46s/19905.44u sec elapsed 22919.25 sec LOG: performsort starting: CPU 2686.35s/20121.46u sec elapsed 23164.61 sec LOG: finished writing run 86 to tape 85: CPU 2686.48s/20127.46u sec elapsed 23170.74 sec LOG: finished writing final run 87 to tape 86: CPU 2688.70s/20220.72u sec elapsed 23266.35 sec LOG: performsort done (except 87-way final merge): CPU 2691.55s/20224.35u sec elapsed 23277.44 sec LOG: external sort ended, 7991989 disk blocks used: CPU 3237.80s/27221.09u sec elapsed 31382.50 sec So, a total of almost 9 hours. Clearly there's something wrong here; if I have time I'll try a recompile with GCC and see how it does. Collation is 'C'. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com