Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1F3C91337B39 for ; Tue, 25 Jan 2011 17:41:51 -0400 (AST) 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 01859-05 for ; Tue, 25 Jan 2011 21:41:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149087.authsmtp.net (outmail149087.authsmtp.net [62.13.149.87]) by mail.postgresql.org (Postfix) with ESMTP id 2A230133798E for ; Tue, 25 Jan 2011 17:41:42 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p0PLfgJi027755; Tue, 25 Jan 2011 21:41:42 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 p0PLfd2Z093387; Tue, 25 Jan 2011 21:41:39 GMT Message-ID: <4D3F4392.4010503@agliodbs.com> Date: Tue, 25 Jan 2011 13:41:38 -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> In-Reply-To: <21735.1295990515@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: e4ed7401-28cb-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1AAcx1xOVtbHwkA AnYJWl5QUVd1WS1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoAXx9 UEocOBl7dAZOfzBy ZkdqECVfCRB9cUZ8 X0xcRj8bZGY1aH0W VxIKagNUcgFMehZC YlV+XD1vNG8XDQgF MDQGdxUsOSleIyNR XwdFLFQeTFZDFSQx TgwDGjNnG0AbSj97 JBsjMloRAEsKekI0 eQpnARRBdAQVDgRE Hlol X-Authentic-SMTP: 61633136333939.1014: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/200 X-Sequence-Number: 29222 On 1/25/11 1:21 PM, Tom Lane wrote: > Josh Berkus writes: >> Note: I have this running now on a test box. If someone responds in the >> next couple hours, I can run whatever diagnostics you want on it. >> Otherwise I'll kill it off and start over with debug logging turned on. > > trace_sort would be interesting. OK, I'll need to kill it and restart. Will go ahead. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com