Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id F016D1337B4A for ; Wed, 16 Feb 2011 03:33:35 -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 61168-10 for ; Wed, 16 Feb 2011 07:33:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id D672C133616B for ; Wed, 16 Feb 2011 03:33:27 -0400 (AST) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0MgYEB-1PTnU42ZvD-00NkyH; Wed, 16 Feb 2011 08:33:24 +0100 Message-ID: <4D5B7DC2.6030807@2ndquadrant.com> Date: Wed, 16 Feb 2011 02:33:22 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Kevin Grittner CC: pgsql-performance@postgresql.org, =?ISO-8859-15?Q?Thomas_P=F6hler?= , Verteiler_A-Team , bm@turtle-entertainment.de, Felix Feinhals Subject: Re: high user cpu, massive SELECTs, no io waiting problem References: <4D5A6C60020000250003AA98@gw.wicourts.gov> In-Reply-To: <4D5A6C60020000250003AA98@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:xXMa2QAOt1nZnX7Ja4eVZDZEI0d0ex8h+1Ihq22do92 qvvYoD7Pzp+7vXmxqa0ap6+7Aknxqc2axdFAk0VyfjJgXZzxDZ JquLMQeszg83BHX4AwzRKTz9o8O1v5hwFFNHouWmp9uppmvnAt lqshCJKN/YPgByAFdFVX8B8ieyiTvxAt6D76Ug3tHBj3CsDBXl NRP03aA9U75/tdc5CUwrSw7v+RRI/mEy5bIziduCgw= 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: 201102/405 X-Sequence-Number: 42543 Kevin Grittner wrote: > Could you show your postgresql.conf file, with all comments removed I just added a sample query to provide the data we always want here without people having to edit their config files, by querying pg_settings for it, to http://wiki.postgresql.org/wiki/Server_Configuration I already updated http://wiki.postgresql.org/wiki/SlowQueryQuestions and http://wiki.postgresql.org/wiki/Guide_to_reporting_problems to mention this too. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books