Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 065D8B5DBC1 for ; Fri, 10 Jun 2011 11:16:53 -0300 (ADT) 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 78562-08 for ; Fri, 10 Jun 2011 14:16:45 +0000 (UTC) X-Greylist: delayed 00:09:59.216898 by SQLgrey-1.7.6 Received: from 98.mail-out.ovh.net (8.98.mail-out.ovh.net [87.98.178.8]) by mail.postgresql.org (Postfix) with ESMTP id 1DD36B5D944 for ; Fri, 10 Jun 2011 11:16:46 -0300 (ADT) Received: from mail30.ha.ovh.net (b6.ovh.net [213.186.33.56]) by 98.mail-out.ovh.net (Postfix) with SMTP id 9A5BD54F599 for ; Fri, 10 Jun 2011 15:57:25 +0200 (CEST) Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 10 Jun 2011 15:57:27 +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; 10 Jun 2011 15:57:26 +0200 Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes In-Reply-To: <000601cc2761$a2e3a280$e8aae780$@devshock.com> References: <000601cc2761$a2e3a280$e8aae780$@devshock.com> Subject: Re: how much postgres can scale up? To: pgsql-performance@postgresql.org, "Anibal David Acosta" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Pierre C" Date: Fri, 10 Jun 2011 15:57:25 +0200 Message-ID: User-Agent: Opera Mail/11.10 (Linux) X-Ovh-Tracer-Id: 2505690243322938929 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-VR-SPAMSTATE: OK X-VR-SPAMSCORE: -100 X-VR-SPAMCAUSE: Vade Retro 01.320.21 AV+AS Profile: OVH; Bailout: 300; @!Recipients (-100) 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: 201106/121 X-Sequence-Number: 44054 > When 1 client connected postgres do 180 execution per second This is suspiciously close to 10.000 executions per minute. You got 10k RPM disks ? How's your IO system setup ? Try setting synchronous_commit to OFF in postgresql.conf and see if that changes the results. That'll give useful information.