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 C68693A29B0 for ; Tue, 18 Jan 2005 22:49:41 +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 82187-03 for ; Tue, 18 Jan 2005 22:49:27 +0000 (GMT) Received: from mail.blogtap.com (66.241.8.26.maxuptime.com [66.241.8.26]) by svr1.postgresql.org (Postfix) with ESMTP id E52D33A295C for ; Tue, 18 Jan 2005 22:49:29 +0000 (GMT) Received: from WORKSTATION (c-24-1-91-108.client.comcast.net [24.1.91.108]) by mail.blogtap.com (Postfix) with ESMTP id BE06568015 for ; Tue, 18 Jan 2005 16:47:30 -0600 (CST) Message-ID: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION> From: "Kevin Schroeder" To: Subject: Swapping on Solaris Date: Tue, 18 Jan 2005 16:49:35 -0600 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/227 X-Sequence-Number: 9917 Hello, I'm running PostgreSQL on a Solaris 8 system with 2GB of RAM and I'm having some difficulty getting PostgreSQL to use the available RAM. My RAM settings in postgresql.conf are shared_buffers = 8192 # min 16, at least max_connections*2, 8KB each sort_mem = 131072 # min 64, size in KB vacuum_mem = 131072 # min 1024, size in KB Ignoring the fact that the sort and vacuum numbers are really high, this is what Solaris shows me when running top: Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free For some reason I have 1.25GB of free RAM but PostgreSQL seems compelled to swap to the hard drive rather than use that RAM. I have the shared buffers set as high as the Solaris kernel will let me. I also know that Solaris will cache frequently used files in RAM, thereby lowering the amount of RAM available to an application, but my understanding is that Solaris will dump that cache if an application or the kernel itself requires it. The system has about 1,000 active email users using unix mailboxes which could what is keeping the database from exploiting as much RAM as available but my primary concern is to allow PostgreSQL to use as much RAM as it requires without swapping. What can I do to force the system to allow PostgreSQL to do this? Regards, Kevin Schroeder