From owner-freebsd-stable@FreeBSD.ORG Mon Dec 3 09:50:55 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 4A48216A418; Mon, 3 Dec 2007 09:50:55 +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 7D0DC13C458; Mon, 3 Dec 2007 09:50:54 +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 204857056; Mon, 03 Dec 2007 12:50:28 +0300 Message-ID: <4753D157.80208@chistydom.ru> Date: Mon, 03 Dec 2007 12:50:15 +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 09:50:55 -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. Sorry for the broken top ouptut in previuos message. Here's the correct one. last pid: 70857; load averages: 35.05, 37.11, 33 up 25+23:08:00 12:46:29 94 processes: 46 running, 48 sleeping CPU: 17.0% user, 0.0% nice, 80.5% system, 0.2% interrupt, 2.3% idle Mem: 1209M Active, 1890M Inact, 494M Wired, 143M Cache, 214M Buf, 127M Free Swap: 2048M Total, 72K Used, 2048M Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAN 70557 pgsql 1 131 0 1068M 662M RUN 0 0:23 26.03% postgr 70840 pgsql 1 132 0 1070M 167M CPU6 5 0:02 21.01% postgr 70761 pgsql 1 128 0 1069M 384M RUN 0 0:04 18.91% postgr 70766 pgsql 1 129 0 1069M 414M RUN 7 0:05 18.17% postgr 70784 pgsql 1 128 0 1071M 374M RUN 3 0:04 17.31% postgr 70758 pgsql 1 128 0 1075M 443M RUN 0 0:05 16.91% postgr 70783 pgsql 1 128 0 1073M 393M RUN 0 0:05 16.86% postgr 70781 pgsql 1 128 0 1073M 389M RUN 0 0:05 16.71% postgr 70755 pgsql 1 128 0 1067M 387M RUN 4 0:05 16.67% postgr 70765 pgsql 1 128 0 1075M 424M CPU5 0 0:05 16.51% postgr 70764 pgsql 1 128 0 1069M 388M RUN 6 0:05 16.45% postgr 70786 pgsql 1 128 0 1069M 361M RUN 1 0:04 16.23% postgr 70785 pgsql 1 128 0 1071M 358M RUN 4 0:04 15.76% postgr 70788 pgsql 1 128 0 1069M 330M RUN 0 0:04 15.46% postgr 70795 pgsql 1 -16 0 1068M 300M vmpfw 0 0:04 15.07% postgr 70803 pgsql 1 128 0 1068M 250M RUN 7 0:03 14.71% postgr 70802 pgsql 1 128 0 1068M 268M RUN 0 0:03 14.19% postgr 70805 pgsql 1 128 0 1068M 249M RUN 0 0:03 14.04% postgr 70798 pgsql 1 128 0 1070M 297M RUN 0 0:03 13.92% postgr 70792 pgsql 1 128 0 1068M 288M RUN 0 0:04 13.90% postgr 70804 pgsql 1 128 0 1068M 238M RUN 0 0:03 13.29% postgr 70808 pgsql 1 128 0 1068M 216M RUN 3 0:03 13.28% postgr 70811 pgsql 1 128 0 1069M 212M RUN 0 0:03 12.81% postgr 70833 pgsql 1 130 0 1068M 133M CPU2 3 0:02 12.77% postgr 70843 pgsql 1 131 0 1068M 57636K RUN 7 0:01 12.13% postgr 70834 pgsql 1 130 0 1068M 111M CPU1 2 0:01 11.53% postgr 70850 pgsql 1 132 0 1067M 46620K RUN 1 0:00 11.28% postgr 70817 pgsql 1 128 0 1068M 150M RUN 0 0:02 10.45% postgr 70844 pgsql 1 131 0 1067M 73296K RUN 4 0:01 10.14% postgr 70815 pgsql 1 128 0 1068M 143M RUN 2 0:01 9.57% postgr 70819 pgsql 1 128 0 1068M 158M RUN 4 0:02 9.43% postgr 70832 pgsql 1 129 0 1067M 99M RUN 1 0:01 9.42% postgr With best regards, Alexey Popov