Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 655AF9FB319 for ; Tue, 3 Jul 2007 17:18:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 13135-03 for ; Tue, 3 Jul 2007 17:18:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 29AA79FA4AA for ; Tue, 3 Jul 2007 17:18:41 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I5opa-00008G-LJ for pgsql-performance@postgresql.org; Tue, 03 Jul 2007 13:18:38 -0700 Message-ID: <11419885.post@talk.nabble.com> Date: Tue, 3 Jul 2007 13:18:38 -0700 (PDT) From: smiley2211 To: pgsql-performance@postgresql.org Subject: Re: Query is taking 5 HOURS to Complete on 8.1 version In-Reply-To: <11416966.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com References: <11416966.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.942 tagged_above=0 required=5 tests=AWL=0.203, BAYES_05=-1.11, FORGED_YAHOO_RCVD=1.849 X-Spam-Level: X-Archive-Number: 200707/23 X-Sequence-Number: 25707 TOP shows CPU at 100% while executed the EXPLAIN ANALYZE...what does this mean? 17519 postgres 25 0 3470m 43m 39m R 100 0.3 28:50.53 postmaster -- View this message in context: http://www.nabble.com/Query-is-taking-5-HOURS-to-Complete-on-8.1-version-tf4019778.html#a11419885 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.