Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D82F51337C79 for ; Mon, 11 Apr 2011 15:19:21 -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 02372-06-4 for ; Mon, 11 Apr 2011 18:19:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (unknown [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 72F381337D55 for ; Mon, 11 Apr 2011 15:13:17 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 7BC97348024; Mon, 11 Apr 2011 11:12:57 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pt4t1ddOO4zJ; Mon, 11 Apr 2011 11:12:55 -0700 (PDT) Received: from www.commandprompt.com (spinlock.commandprompt.com.commandprompt.com [207.173.203.215]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 5B900348022; Mon, 11 Apr 2011 11:12:55 -0700 (PDT) MIME-Version: 1.0 Date: Mon, 11 Apr 2011 11:12:55 -0700 From: "Joshua D. Drake" To: Kevin Grittner Cc: , Glyn Astill Subject: Re: Linux: more cores =?UTF-8?Q?=3D=20less=20concurrency=2E?= Organization: Command Prompt, Inc. In-Reply-To: <4DA2FD7B020000250003C678@gw.wicourts.gov> References: <860299.67368.qm@web26003.mail.ukl.yahoo.com> <4DA2FD7B020000250003C678@gw.wicourts.gov> Message-ID: <8b76c51ad6db2e458431ef73bcdd2759@commandprompt.com> X-Sender: jd@commandprompt.com User-Agent: RoundCube Webmail/0.2.1 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201104/109 X-Sequence-Number: 43171 On Mon, 11 Apr 2011 13:09:15 -0500, "Kevin Grittner" wrote: > Glyn Astill wrote: > >> The new server uses 4 x 8 core Xeon X7550 CPUs at 2Ghz > > Which has hyperthreading. > >> our current servers are 2 x 4 core Xeon E5320 CPUs at 2Ghz. > > Which doesn't have hyperthreading. > > PostgreSQL often performs worse with hyperthreading than without. > Have you turned HT off on your new machine? If not, I would start > there. And then make sure you aren't running CFQ. JD > > -Kevin -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997