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 A02C33A2B22 for ; Wed, 19 Jan 2005 07:37:06 +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 42102-06 for ; Wed, 19 Jan 2005 07:37:02 +0000 (GMT) Received: from mail.coretech.co.nz (coretech.co.nz [202.36.204.41]) by svr1.postgresql.org (Postfix) with ESMTP id C03F63A25A3 for ; Wed, 19 Jan 2005 07:37:01 +0000 (GMT) Received: (qmail 2778 invoked from network); 19 Jan 2005 07:36:56 -0000 Received: from 218-101-12-253.paradise.net.nz (HELO ?192.168.1.11?) (218.101.12.253) by 0 with SMTP; 19 Jan 2005 07:36:56 -0000 Message-ID: <41EE0F05.9080901@coretech.co.nz> Date: Wed, 19 Jan 2005 20:40:53 +1300 From: Mark Kirkwood User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.2) Gecko/20041016 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> In-Reply-To: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION> 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=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/228 X-Sequence-Number: 9918 Kevin Schroeder wrote: > > > 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 > Maybe check the swap usage with 'swap -l' which reports reliably if any (device or file) swap is actually used. I think Solaris 'top' does some strange accounting to calculate the 'swap in use' value (like including used memory). It looks to me like you are using no (device or file) swap at all, and have 1.3G of real memory free, so could in fact give Postgres more of it :-) regards Mark