X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4B8B8D1C4C2 for ; Tue, 20 Apr 2004 00:47:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37226-02 for ; Tue, 20 Apr 2004 00:47:50 -0300 (ADT) Received: from srvr3.iniquinet.com (srvr2.iniquinet.com [64.240.87.12]) by svr1.postgresql.org (Postfix) with SMTP id 6AEDDD1B482 for ; Tue, 20 Apr 2004 00:47:49 -0300 (ADT) Received: (qmail 14697 invoked by uid 104); 20 Apr 2004 03:47:47 -0000 Received: from Robert_Creager@LogicalChaos.org by srvr3.iniquinet.com by uid 101 with qmail-scanner-1.15 (clamscan: 0.65. spamassassin: 2.55. Clear:SA:0(-7.4/6.0):. Processed in 32.951673 secs); 20 Apr 2004 03:47:47 -0000 Received: from unknown (HELO thunder.mshome.net) (216.58.165.126) by srvr3.iniquinet.com with SMTP; 20 Apr 2004 03:47:14 -0000 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id 998C994857; Mon, 19 Apr 2004 21:47:13 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id 263B694857; Mon, 19 Apr 2004 21:47:10 -0600 (MDT) Date: Mon, 19 Apr 2004 21:47:02 -0600 From: Robert Creager To: Tom Lane Cc: josh@agliodbs.com, Joe Conway , "scott.marlowe" , Bruce Momjian , lutzeb@aeccom.com, pgsql-performance@postgresql.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon Message-Id: <20040419214702.70e5c9b6@thunder.mshome.net> In-Reply-To: <1931.1082422389@sss.pgh.pa.us> References: <40843E63.7050101@joeconway.com> <200404191455.04068.josh@agliodbs.com> <1407.1082419316@sss.pgh.pa.us> <1931.1082422389@sss.pgh.pa.us> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed version 0.9.9claws (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Mon__19_Apr_2004_21_47_02_-0600_TKk0qNlhGAUFCcfZ" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/287 X-Sequence-Number: 6587 --Signature=_Mon__19_Apr_2004_21_47_02_-0600_TKk0qNlhGAUFCcfZ Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit When grilled further on (Mon, 19 Apr 2004 20:53:09 -0400), Tom Lane confessed: > I wrote: > > Here is a test case. > > Hmmm ... I've been able to reproduce the CS storm on a dual Athlon, > which seems to pretty much let the Xeon per se off the hook. Anybody > got a multiple Opteron to try? Totally non-Intel CPUs? > > It would be interesting to see results with non-Linux kernels, too. > Same problem on my dual AMD MP with 2.6.5 kernel using two sessions of your test, but maybe not quite as severe. The highest CS values I saw was 102k, with some non-db number crunching going on in parallel with the test. 'Average' about 80k with two instances. Using the anticipatory scheduler. A single instance pulls in around 200-300 CS, and no tests running around 200-300 CS (i.e. no CS difference). A snipet: procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- 3 0 284 90624 93452 1453740 0 0 0 0 1075 76548 83 17 0 0 6 0 284 125312 93452 1470196 0 0 0 0 1073 87702 78 22 0 0 3 0 284 178392 93460 1420208 0 0 76 298 1083 67721 77 24 0 0 4 0 284 177120 93460 1421500 0 0 1104 0 1054 89593 80 21 0 0 5 0 284 173504 93460 1425172 0 0 3584 0 1110 65536 81 19 0 0 4 0 284 169984 93460 1428708 0 0 3456 0 1098 66937 81 20 0 0 6 0 284 170944 93460 1428708 0 0 8 0 1045 66065 81 19 0 0 6 0 284 167288 93460 1428776 0 0 0 8 1097 75560 81 19 0 0 6 0 284 136296 93460 1458356 0 0 0 0 1036 80808 75 26 0 0 5 0 284 132864 93460 1461688 0 0 0 0 1007 76071 84 17 0 0 4 0 284 132880 93460 1461688 0 0 0 0 1079 86903 82 18 0 0 5 0 284 132880 93460 1461688 0 0 0 0 1078 79885 83 17 0 0 6 0 284 132648 93460 1461688 0 0 0 760 1228 66564 86 14 0 0 6 0 284 132648 93460 1461688 0 0 0 0 1047 69741 86 15 0 0 6 0 284 132672 93460 1461688 0 0 0 0 1057 79052 84 16 0 0 5 0 284 132672 93460 1461688 0 0 0 0 1054 81109 82 18 0 0 5 0 284 132736 93460 1461688 0 0 0 0 1043 91725 80 20 0 0 Cheers, Rob -- 21:33:03 up 3 days, 1:10, 3 users, load average: 5.05, 4.67, 4.22 Linux 2.6.5-01 #5 SMP Tue Apr 6 21:32:39 MDT 2004 --Signature=_Mon__19_Apr_2004_21_47_02_-0600_TKk0qNlhGAUFCcfZ Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEYEARECAAYFAkCEnT4ACgkQLQ/DKuwDYzlP+gCfUEjce4uOlds2UYi74gQF4x74 RZoAn1NxiPBUks7VXrPJesieH371NWYp =cWZK -----END PGP SIGNATURE----- --Signature=_Mon__19_Apr_2004_21_47_02_-0600_TKk0qNlhGAUFCcfZ--