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 C69099DCF5B for ; Mon, 20 Mar 2006 10:45:02 -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 89253-09 for ; Mon, 20 Mar 2006 10:45:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 72F189DCCED for ; Mon, 20 Mar 2006 10:45:00 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id EE3B756423; Mon, 20 Mar 2006 08:45:04 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Mon, 20 Mar 2006 08:45:04 -0600 Date: Mon, 20 Mar 2006 08:45:04 -0600 From: "Jim C. Nasby" To: Scott Marlowe Cc: Kenji Morishige , pgsql-performance@postgresql.org Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Message-ID: <20060320144503.GR15742@pervasive.com> References: <20060317221116.GA14661@juniper.net> <1142636433.1141.33.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1142636433.1141.33.camel@state.g2switchworks.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060320:smarlowe@g2switchworks.com::PSO5VOPuhJso0c0X:00000000000 0000000000000000000000009d6T X-Hashcash: 1:20:060320:kenjim@juniper.net::Gi3gJQwMg/z5rTKv:0000000000000000000 0000000000000000000000002SmI X-Hashcash: 1:20:060320:pgsql-performance@postgresql.org::bxZgs0fGFPqd9OsI:00000 0000000000000000000000000Owt X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/328 X-Sequence-Number: 17765 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. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461