X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 189E8329FF2 for ; Sat, 9 Oct 2004 00:30:12 +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 95808-08 for ; Fri, 8 Oct 2004 23:29:59 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 48472329F17 for ; Sat, 9 Oct 2004 00:30:01 +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 6480816; Fri, 08 Oct 2004 16:31:19 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness ... Date: Fri, 8 Oct 2004 16:31:41 -0700 User-Agent: KMail/1.6.2 Cc: Tom Lane , testperf-general@pgfoundry.org, Jan Wieck References: <200410081443.16109.josh@agliodbs.com> <21365.1097274088@sss.pgh.pa.us> In-Reply-To: <21365.1097274088@sss.pgh.pa.us> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200410081631.41545.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/117 X-Sequence-Number: 8593 Tom, > BTW, what is the actual size of the test database (disk footprint wise) > and how much of that do you think is heavily accessed during the run? > It's possible that the test conditions are such that adjusting > shared_buffers isn't going to mean anything anyway. The raw data is 32GB, but a lot of the activity is incremental, that is inserts and updates to recent inserts. Still, according to Mark, most of the data does get queried in the course of filling orders. -- --Josh Josh Berkus Aglio Database Solutions San Francisco