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 057A73A41A6 for ; Wed, 19 Jan 2005 15:30:54 +0000 (GMT) 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 01441-02 for ; Wed, 19 Jan 2005 15:30:40 +0000 (GMT) Received: from unicorn.rentec.com (unicorn.rentec.com [216.223.240.9]) by svr1.postgresql.org (Postfix) with ESMTP id 0C2A33A4163 for ; Wed, 19 Jan 2005 15:30:40 +0000 (GMT) Received: from wren.rentec.com (wren.rentec.com [192.5.35.106]) by unicorn.rentec.com (8.13.1/8.12.1) with ESMTP id j0JFUXU2027289 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL); Wed, 19 Jan 2005 10:30:34 -0500 (EST) X-Rentec: external Received: from [172.26.132.145] (hoopoe.rentec.com [172.26.132.145]) by wren.rentec.com (8.13.1/8.12.1) with ESMTP id j0JFUX2e005393; Wed, 19 Jan 2005 10:30:33 -0500 (EST) Message-ID: <41EE7D19.4060503@rentec.com> Date: Wed, 19 Jan 2005 10:30:33 -0500 From: Alan Stange Reply-To: stange@rentec.com Organization: Renaissance Technologies Corp. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kevin Schroeder Cc: pgsql-performance@postgresql.org Subject: Re: Swapping on Solaris References: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION> <41EE0F05.9080901@coretech.co.nz> <41EE65FC.2000909@rentec.com> <00d601c4fe33$89682eb0$0200a8c0@WORKSTATION> In-Reply-To: <00d601c4fe33$89682eb0$0200a8c0@WORKSTATION> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/238 X-Sequence-Number: 9928 Kevin Schroeder wrote: > I suspect that the memory is being used to cache files as well since > the email boxes are using unix mailboxes, for the time being. With > people checking their email sometimes once per minute I can see why > Solaris would want to cache those files. Perhaps my question would be > more appropriate to a Solaris mailing list since what I really want to > do is get Solaris to simply allow PostgreSQL to use more RAM and > reduce the amount of RAM used for file caching. I would have thought > that Solaris gives some deference to a running application that's > being swapped than for a file cache. > > Is there any way to set custom parameters on Solaris' file-caching > behavior to allow PostgreSQL to use more physical RAM? Your explanation doesn't sound quite correct. If postgresql malloc()'s some memory and uses it, the file cache will be reduced in size and the memory given to postgresql. But if postgresql doesn't ask for or use the memory, then solaris is going to use it for something else. There's nothing in Solaris that doesn't "allow" postgresql to use more RAM. -- Alan