Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 30E241337BCA
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 17 Feb 2011 06:17:16 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 54721-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 17 Feb 2011 10:17:09 +0000 (UTC)
X-Greylist: delayed 02:46:37.885501 by SQLgrey-1.7.6
Received: from 70.mail-out.ovh.net (10.70.mail-out.ovh.net [178.33.254.164])
	by mail.postgresql.org (Postfix) with SMTP id 44E311337B77
	for <pgsql-performance@postgresql.org>;
	Thu, 17 Feb 2011 06:17:07 -0400 (AST)
Received: (qmail 5055 invoked by uid 503); 17 Feb 2011 07:30:03 -0000
Received: from b6.ovh.net (HELO mail606.ha.ovh.net) (213.186.33.56)
	by 70.mail-out.ovh.net with SMTP; 17 Feb 2011 07:30:03 -0000
Received: from b0.ovh.net (HELO queueout) (213.186.33.50)
	by b0.ovh.net with SMTP; 17 Feb 2011 09:30:26 +0200
Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13)
	(lists%peufeu.com@88.161.102.87)
	by ns0.ovh.net with SMTP; 17 Feb 2011 09:30:25 +0200
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: =?utf-8?Q?Thomas_P=C3=B6hler?= <tp@turtle-entertainment.de>, "Greg Smith"
	<greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
References: 
 <F1CD4AC5B4A5024AAB60E28A82A8450A03CEB0C7@winexch1.office.turtle-entertainment.de>
	<4D5A6C60020000250003AA98@gw.wicourts.gov>
	<4D5B7DC2.6030807@2ndquadrant.com>
	<4D5B8CCC020000250003AAFD@gw.wicourts.gov>
	<4D5BE56B.4030307@2ndquadrant.com>
	<AANLkTi=mYVFE7QYfrTskUMuJXO34wbzY=1SNi+qgbUhf@mail.gmail.com>
	<4D5BA236020000250003AB0E@gw.wicourts.gov>
	<F1CD4AC5B4A5024AAB60E28A82A8450A03CEB2DA@winexch1.office.turtle-entertainment.de>
	<4D5C3531.3070308@2ndquadrant.com>
Date: Thu, 17 Feb 2011 08:30:25 +0100
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: "Pierre C" <lists@peufeu.com>
Message-ID: <op.vq1dsz2heorkce@apollo13>
In-Reply-To: <4D5C3531.3070308@2ndquadrant.com>
User-Agent: Opera Mail/10.63 (Linux)
X-Ovh-Tracer-Id: 14884678244701898375
X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net)
X-Ovh-Local: 213.186.33.20 (ns0.ovh.net)
X-Spam-Check: DONE|U 0.5/N
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
X-Spam-Level: 
X-Archive-Number: 201102/424
X-Sequence-Number: 42562

> Thomas Pöhler wrote:

I remember you said you were using nginx and php-fastcgi, how many web  
server boxes do you have, and what are the specs ?