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 76E21D1DF5C for ; Wed, 28 Apr 2004 23:41:48 -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 36471-09 for ; Wed, 28 Apr 2004 23:41:27 -0300 (ADT) Received: from srvr3.iniquinet.com (srvr2.iniquinet.com [64.240.87.12]) by svr1.postgresql.org (Postfix) with SMTP id 4FC30D1EF8B for ; Wed, 28 Apr 2004 21:59:28 -0300 (ADT) Received: (qmail 28632 invoked by uid 104); 29 Apr 2004 00:59:31 -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(-6.5/6.0):. Processed in 32.720762 secs); 29 Apr 2004 00:59:31 -0000 Received: from unknown (HELO thunder.mshome.net) (216.58.165.126) by srvr3.iniquinet.com with SMTP; 29 Apr 2004 00:58:58 -0000 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id EBB3CE805E; Wed, 28 Apr 2004 18:58:57 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id 20001E805E; Wed, 28 Apr 2004 18:58:55 -0600 (MDT) Date: Wed, 28 Apr 2004 18:57:53 -0600 From: Robert Creager To: Josh Berkus Cc: pg@fastcrypt.com, =?ISO-8859-1?Q?Dirk=5FLutzeb=E4ck?= , ohp@pyrenet.fr, Tom Lane , Joe Conway , "scott.marlowe" , Bruce Momjian , pgsql-performance@postgresql.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon Message-Id: <20040428185753.56614b2c@thunder.mshome.net> In-Reply-To: <200404211029.43675.josh@agliodbs.com> References: <408664CF.9040507@aeccom.com> <1082559931.1557.235.camel@localhost.localdomain> <200404211029.43675.josh@agliodbs.com> 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=_Wed__28_Apr_2004_18_57_53_-0600_NKZvs8lnAAF58pWn" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.0 tagged_above=0.0 required=5.0 tests=DRASTIC_REDUCED X-Spam-Level: * X-Archive-Number: 200404/489 X-Sequence-Number: 6789 --Signature=_Wed__28_Apr_2004_18_57_53_-0600_NKZvs8lnAAF58pWn Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit When grilled further on (Wed, 21 Apr 2004 10:29:43 -0700), Josh Berkus confessed: > Dave, > > > After some testing if you use the current head code for s_lock.c which > > has some mods in it to alleviate this situation, and change > > SPINS_PER_DELAY to 10 you can drastically reduce the cs with tom's test. > > I am seeing a slight degradation in throughput using pgbench -c 10 -t > > 1000 but it might be liveable, considering the alternative is unbearable > > in some situations. > > > > Can anyone else replicate my results? > > Can you produce a patch against 7.4.1? I'd like to test your fix against a > real-world database. I would like to see the same, as I have a system that exhibits the same behavior on a production db that's running 7.4.1. Cheers, Rob -- 18:55:22 up 1:40, 4 users, load average: 2.00, 2.04, 2.00 Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004 --Signature=_Wed__28_Apr_2004_18_57_53_-0600_NKZvs8lnAAF58pWn Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEYEARECAAYFAkCQUxEACgkQLQ/DKuwDYzkGIACfVeE6q/BGr/ZwShuQ8pM0ch2F YlcAoIQSiwr7bp0G1OuazNm2OkqES15D =XbD0 -----END PGP SIGNATURE----- --Signature=_Wed__28_Apr_2004_18_57_53_-0600_NKZvs8lnAAF58pWn--