X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9499B9DCA74 for ; Mon, 20 Mar 2006 12:20:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10529-08 for ; Mon, 20 Mar 2006 12:20:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 605689DC888 for ; Mon, 20 Mar 2006 12:20:21 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 20 Mar 2006 16:20:20 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 20 Mar 2006 10:20:20 -0600 Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & From: Scott Marlowe To: "Jim C. Nasby" Cc: Kenji Morishige , pgsql-performance@postgresql.org In-Reply-To: <20060320144503.GR15742@pervasive.com> References: <20060317221116.GA14661@juniper.net> <1142636433.1141.33.camel@state.g2switchworks.com> <20060320144503.GR15742@pervasive.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1142871620.17883.4.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 20 Mar 2006 10:20:20 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.147 required=5 tests=[AWL=0.146, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.147 X-Spam-Level: X-Archive-Number: 200603/333 X-Sequence-Number: 17770 On Mon, 2006-03-20 at 08:45, Jim C. Nasby wrote: > On Fri, Mar 17, 2006 at 05:00:34PM -0600, Scott Marlowe wrote: > > > last pid: 5788; load averages: 0.32, 0.31, 0.28 up 127+15:16:08 13:59:24 > > > 169 processes: 1 running, 168 sleeping > > > CPU states: 5.4% user, 0.0% nice, 9.9% system, 0.0% interrupt, 84.7% idle > > > Mem: 181M Active, 2632M Inact, 329M Wired, 179M Cache, 199M Buf, 81M Free > > > Swap: 4096M Total, 216K Used, 4096M Free > > > > > > PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND > > > 14501 pgsql 2 0 254M 242M select 2 76:26 1.95% 1.95% postgre > > > 5720 root 28 0 2164K 1360K CPU0 0 0:00 1.84% 0.88% top > > > 5785 pgsql 2 0 255M 29296K sbwait 0 0:00 3.00% 0.15% postgre > > > 5782 pgsql 2 0 255M 11900K sbwait 0 0:00 3.00% 0.15% postgre > > > 5772 pgsql 2 0 255M 11708K sbwait 2 0:00 1.54% 0.15% postgre > > > > That doesn't look good. Is this machine freshly rebooted, or has it > > been running postgres for a while? 179M cache and 199M buffer with 2.6 > > gig inactive is horrible for a machine running a 10gig databases. > > No, this is perfectly fine. Inactive memory in FreeBSD isn't the same as > Free. It's the same as 'active' memory except that it's pages that > haven't been accessed in X amount of time (between 100 and 200 ms, I > think). When free memory starts getting low, FBSD will start moving > pages from the inactive queue to the free queue (possibly resulting in > writes to disk along the way). > > IIRC, Cache is the directory cache, and Buf is disk buffers, which is > somewhat akin to shared_buffers in PostgreSQL. So, then, the inact is pretty much the same as kernel buffers in linux?