From owner-freebsd-stable@FreeBSD.ORG Mon Dec 3 12:52:02 2007 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9214216A418; Mon, 3 Dec 2007 12:52:02 +0000 (UTC) (envelope-from lol@chistydom.ru) Received: from hermes.hw.ru (hermes.hw.ru [80.68.240.91]) by mx1.freebsd.org (Postfix) with ESMTP id 9916313C45A; Mon, 3 Dec 2007 12:52:00 +0000 (UTC) (envelope-from lol@chistydom.ru) Received: from [80.68.244.40] (account a_popov@rbc.ru [80.68.244.40] verified) by hermes.hw.ru (CommuniGate Pro SMTP 5.0.14) with ESMTPA id 204919255; Mon, 03 Dec 2007 15:51:36 +0300 Message-ID: <4753FBCB.6010607@chistydom.ru> Date: Mon, 03 Dec 2007 15:51:23 +0300 From: Alexey Popov User-Agent: Thunderbird 2.0.0.6 (X11/20070924) MIME-Version: 1.0 To: Mark Linimon References: <20071201213732.GA16638@cannabis.dataforce.net> <1497741406.20071201230441@rulez.sk> <20071202174540.GA29572@cannabis.dataforce.net> <200712020844.49718.linimon@FreeBSD.org> <4753C9E4.1060200@chistydom.ru> In-Reply-To: <4753C9E4.1060200@chistydom.ru> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-stable@freebsd.org, Alexey Vlasov Subject: Re: 2 x quad-core system is slower that 2 x dual core on FreeBSD X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 03 Dec 2007 12:52:02 -0000 Hi Alexey Popov wrote: > Now we also have terribly performing PostgreSQL on 8-core server. We > noticed the slowdown after moving PostgreSQL from 2xXeon 3.0 > Apache+PostgreSQL server to dedicated PostgreSQL server. I collected > some stats (see attach) before moving to Linux. FYI there's top output on the same server with only 2 cores enabled (it works much better than with 8 cores): last pid: 38266; load averages: 7.11, 5.01, 4. up 0+01:33:40 15:51:20 53 processes: 7 running, 46 sleeping CPU: 69.1% user, 0.0% nice, 29.8% system, 0.4% interrupt, 0.7% idle Mem: 835M Active, 1743M Inact, 443M Wired, 168K Cache, 214M Buf, 882M Free Swap: 2048M Total, 2048M Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAN 38139 pgsql 1 132 0 1126M 639M RUN 0 0:06 29.84% postgr 38245 pgsql 1 130 0 1071M 361M RUN 1 0:01 19.61% postgr 38249 pgsql 1 130 0 1068M 320M CPU1 0 0:01 15.76% postgr 38251 pgsql 1 130 0 1069M 317M RUN 1 0:01 15.06% postgr 38254 pgsql 1 130 0 1067M 161M RUN 1 0:01 14.36% postgr 694 pgsql 1 130 0 1066M 4816K select 0 0:37 0.00% postgr 698 pgsql 1 96 0 15588K 4724K select 0 0:28 0.00% postgr 697 pgsql 1 96 0 1066M 298M select 0 0:14 0.00% postgr 1748 root 1 96 0 7044K 2252K select 0 0:05 0.00% top 18775 root 1 96 0 7008K 2220K select 0 0:02 0.00% top 627 root 1 96 0 18120K 5872K select 0 0:02 0.00% snmpd 1704 vich 1 96 0 30616K 4248K select 0 0:00 0.00% sshd 695 pgsql 1 96 0 15392K 4496K select 1 0:00 0.00% postgr 16781 null 1 96 0 30616K 4220K select 0 0:00 0.00% sshd 655 root 1 96 0 7732K 2324K select 0 0:00 0.00% ntpd 556 root 1 96 0 3652K 1192K select 1 0:00 0.00% syslog With best regards, Alexey Popov