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 21B58D1B18A for ; Thu, 20 May 2004 19:15:59 -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 48356-03 for ; Thu, 20 May 2004 19:15:41 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A8B11D1CAA0 for ; Thu, 20 May 2004 19:15:38 -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 i4KMEq7T024679; Thu, 20 May 2004 18:14:52 -0400 (EDT) To: josh@agliodbs.com Cc: Bruce Momjian , pg@fastcrypt.com, Robert Creager , =?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: <200405201452.07833.josh@agliodbs.com> References: <200405200120.i4K1KKm06350@candle.pha.pa.us> <24373.1085020886@sss.pgh.pa.us> <200405201452.07833.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Thu, 20 May 2004 14:52:07 -0700" Date: Thu, 20 May 2004 18:14:52 -0400 Message-ID: <24678.1085091292@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/178 X-Sequence-Number: 7009 Josh Berkus writes: > I'm really curious, BTW, about how all of Jan's changes to buffer > usage in 7.5 affect this issue. Has anyone tested it on a recent > snapshot? Won't help. (1) Theoretical argument: the problem case is select-only and touches few enough buffers that it need never visit the kernel. The buffer management algorithm is thus irrelevant since there are never any decisions for it to make. If anything CVS tip will have a worse problem because its more complicated management algorithm needs to spend longer holding the BufMgrLock. (2) Experimental argument: I believe that I did check the self-contained test case we eventually developed against CVS tip on one of Red Hat's SMP machines, and indeed it was unhappy. regards, tom lane