Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 400F1B5DBBD for ; Fri, 10 Jun 2011 09:37:50 -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 38140-01 for ; Fri, 10 Jun 2011 12:37:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id 9D92BB5DBB7 for ; Fri, 10 Jun 2011 09:37:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id 007B710D; Fri, 10 Jun 2011 08:37:43 -0400 (EDT) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id R4lbAKQpPmIV; Fri, 10 Jun 2011 08:37:42 -0400 (EDT) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id 02EAA2D; Fri, 10 Jun 2011 08:37:42 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 0564EAF4C3; Fri, 10 Jun 2011 20:37:41 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id PfXxPykIe-nG; Fri, 10 Jun 2011 20:37:35 +0800 (WST) Received: from [10.1.1.5] (124-169-230-7.dyn.iinet.net.au [124.169.230.7]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 397E1AF4C2; Fri, 10 Jun 2011 20:37:35 +0800 (WST) Message-ID: <4DF21007.2010807@postnewspapers.com.au> Date: Fri, 10 Jun 2011 20:37:27 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110428 Fedora/3.1.10-1.fc15 Thunderbird/3.1.10 MIME-Version: 1.0 To: bakkiya CC: pgsql-performance@postgresql.org Subject: Re: 100% CPU Utilization when we run queries. References: <1307506768241-4465765.post@n5.nabble.com> <4DEF037E.9020105@postnewspapers.com.au> <1307691557007-4475458.post@n5.nabble.com> In-Reply-To: <1307691557007-4475458.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.788 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201106/116 X-Sequence-Number: 44049 On 06/10/2011 03:39 PM, bakkiya wrote: > http://postgresql.1045698.n5.nabble.com/file/n4475458/untitled.bmp 404 file not found. That's ... not overly useful. Again, *PLEASE* read http://wiki.postgresql.org/wiki/Guide_to_reporting_problems and try posting again with enough information that someone might be able to actually help you. As Marti mentioned and as recommended by the link above, you should particularly focus on the questions here: https://wiki.postgresql.org/wiki/SlowQueryQuestions If you want help from people here, you will need to make enough effort to collect the information required to help you. -- Craig Ringer