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 BC240D1B4A8 for ; Thu, 20 May 2004 01:00:22 -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 47644-09 for ; Thu, 20 May 2004 00:59:46 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B3257D1CB08 for ; Thu, 20 May 2004 00:59:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i4K3wujN025438; Wed, 19 May 2004 23:58:56 -0400 (EDT) To: Bruce Momjian Cc: pg@fastcrypt.com, Robert Creager , Josh Berkus , =?ISO-8859-1?Q?Dirk=5FLutzeb=E4ck?= , ohp@pyrenet.fr, Joe Conway , "scott.marlowe" , pgsql-performance@postgresql.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon In-reply-to: <200405200302.i4K32G721749@candle.pha.pa.us> References: <200405200302.i4K32G721749@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 19 May 2004 23:02:16 -0400" Date: Wed, 19 May 2004 23:58:56 -0400 Message-ID: <25437.1085025536@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/164 X-Sequence-Number: 6995 Bruce Momjian writes: > Tom Lane wrote: >> ... The SMP issue seems to be not with whether there is >> instantaneous contention for the locked datastructure, but with the cost >> of making it possible for processor B to acquire a lock recently held by >> processor A. > I see. I don't even see a TODO in there. :-( Nothing more specific than "investigate SMP context switching issues", anyway. We are definitely in a research mode here, rather than an engineering mode. ObQuote: "Research is what I am doing when I don't know what I am doing." - attributed to Werner von Braun, but has anyone got a definitive reference? regards, tom lane