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 0D842D1B4ED for ; Mon, 27 Oct 2003 06:33:29 +0000 (GMT) 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 76351-10 for ; Mon, 27 Oct 2003 02:32:57 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 52E83D1B4E5 for ; Mon, 27 Oct 2003 02:32:56 -0400 (AST) Received: from myrealbox.com shridhar_daithankar@smtp-send.myrealbox.com [202.54.11.72] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.43 $ on Novell NetWare via secured & encrypted transport (TLS); Sun, 26 Oct 2003 23:32:47 -0700 Message-ID: <3F9CBC0A.1070706@myrealbox.com> Date: Mon, 27 Oct 2003 12:02:42 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Vivek Khera Cc: Josh Berkus , pgsql-performance@postgresql.org Subject: Re: slow select References: <906E2C446A276048A1BE283F17BCB12CDB4230@encounter.fairind.fairfield.com> <200310221442.56816.josh@agliodbs.com> <200310240822.57737.josh@agliodbs.com> <16281.18548.53239.394135@yertle.int.kciLink.com> In-Reply-To: <16281.18548.53239.394135@yertle.int.kciLink.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/662 X-Sequence-Number: 4410 Vivek Khera wrote: >>>>>>"JB" == Josh Berkus writes: > JB> Actually, what OS's can't use all idle ram for kernel cache? I > JB> should note that in my performance docs .... > > FreeBSD. Limited by the value of "sysctl vfs.hibufspace" from what I > understand. This value is set at boot based on available RAM and some > other tuning parameters. Actually I wanted to ask this question for long time. Can we have guidelines about how to set effective cache size for various OSs? Linux is pretty simple. Everything free is buffer cache. FreeBSD, not so straightforward but there is a sysctl.. How about HP-UX, Solaris and AIX? Other BSDs? and most importantly windows? That could add much value to the tuning guide. Isn't it? Shridhar