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 F329032A892 for ; Mon, 18 Oct 2004 20:17:41 +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 90817-06 for ; Mon, 18 Oct 2004 19:17:38 +0000 (GMT) Received: from smtp109.mail.sc5.yahoo.com (smtp109.mail.sc5.yahoo.com [66.163.170.7]) by svr1.postgresql.org (Postfix) with SMTP id 309F632A887 for ; Mon, 18 Oct 2004 20:17:35 +0100 (BST) Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp109.mail.sc5.yahoo.com with SMTP; 18 Oct 2004 19:17:33 -0000 Received: from [172.21.8.18] (ismtp.afilias.com [216.217.55.254]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id i9IJHH94028842; Mon, 18 Oct 2004 15:17:23 -0400 (EDT) (envelope-from JanWieck@Yahoo.com) Message-ID: <417416B7.4060209@Yahoo.com> Date: Mon, 18 Oct 2004 15:17:11 -0400 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Simon Riggs Cc: josh@agliodbs.com, pgsql-performance@postgresql.org, testperf-general@pgfoundry.org Subject: Re: First set of OSDL Shared Mem scalability results, some References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.6 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200410/263 X-Sequence-Number: 8739 On 10/14/2004 6:36 PM, Simon Riggs wrote: > [...] > I think Jan has said this also in far fewer words, but I'll leave that to > Jan to agree/disagree... I do agree. The total DB size has as little to do with the optimum shared buffer cache size as the total available RAM of the machine. After reading your comments it appears more clear to me. All what those tests did show is the amount of high frequently accessed data in this database population and workload combination. > > I say this: ARC in 8.0 PostgreSQL allows us to sensibly allocate as large a > shared_buffers cache as is required by the database workload, and this > should not be constrained to a small percentage of server RAM. Right. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #