X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5B755329D20; Sat, 16 Oct 2004 22:16:33 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60907-08; Sat, 16 Oct 2004 21:16:26 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id E2C78329D22; Sat, 16 Oct 2004 22:16:27 +0100 (BST) Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6518021; Sat, 16 Oct 2004 14:17:50 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...) Date: Sat, 16 Oct 2004 14:18:26 -0700 User-Agent: KMail/1.6.2 Cc: Tom Lane , pgsql-hackers@postgreSQL.org References: <26068.1097872442@sss.pgh.pa.us> <4664.1097945657@sss.pgh.pa.us> In-Reply-To: <4664.1097945657@sss.pgh.pa.us> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Message-Id: <200410161418.26557.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/529 X-Sequence-Number: 60032 Tom, > We could also get rid of the linear search in UnlockBuffers(). =C2=A0The = only > thing it's for anymore is to release a BM_PIN_COUNT_WAITER flag, and > since a backend could not be doing more than one of those at a time, > we don't really need an array of flags for that, only a single variable. > This does not show in the OSDL results, which I presume means that their > test case is not exercising transaction aborts; In the test, one out of every 100 new order transactions is aborted (about = 1=20 out of 150 transactions overall). --=20 --Josh Josh Berkus Aglio Database Solutions San Francisco