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 1FD7F9DC823 for ; Thu, 9 Feb 2006 02:32:55 -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 59375-03 for ; Thu, 9 Feb 2006 02:32:54 -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 D15DE9DC80C for ; Thu, 9 Feb 2006 02:32:52 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id C334E39842; Thu, 9 Feb 2006 06:32:35 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Thu, 9 Feb 2006 00:32:35 -0600 Date: Thu, 9 Feb 2006 00:32:35 -0600 From: "Jim C. Nasby" To: Ron Cc: pgsql-performance@postgresql.org Subject: Re: Sane configuration options for a WinXP laptop 8.1 install? Message-ID: <20060209063235.GZ57845@pervasive.com> References: <7.0.1.0.2.20060208164655.0382eb40@earthlink.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7.0.1.0.2.20060208164655.0382eb40@earthlink.net> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060209:rjpeace@earthlink.net::/1QTaSY7XftK0lC/:0000000000000000 0000000000000000000000002k4W X-Hashcash: 1:20:060209:pgsql-performance@postgresql.org::Fk8lidNgOJrMLxut:00000 0000000000000000000000003jo4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200602/75 X-Sequence-Number: 17061 On Wed, Feb 08, 2006 at 05:05:02PM -0500, Ron wrote: > In an attempt to save myself some time, I thought I ask The Community > if anyone has guidance here. > > HW: Intel PM (very likely to be upgraded to an AMD Turion when the > proper HW becomes available) w/ 2GB of RAM (shortly to be 4GB) and a > 5400rpm 100GB HD (will be dual 7200rpm 160GB HD's as soon as they > become available) > > OS: The laptop in question is running the latest WinXP service pack > and patches. When the CPU and HD upgrades mentioned above happen, I > will probably start running dual boot FC5 + 64b Windows. > > Possible optional HW: external "box of HDs" for doing and/or > modelling stuff that can't be using only the internal ones. > > I want to get as much performance as I can out of the HW + OS. > > Anyone want to take a stab at what the config files and options > should be for best performance under most circumstances? > > This is intended to be a portable development platform, so opinions > as to which contrib modules are worth/not worth installing is also > appreciated. Off the top of my head... shared_buffers=30000 drop max_connections to what you'll actually be using maintenance_work_mem=100000 work_mem=2000000/max_connections (maybe * 0.9 for some added margin) autovacuum=on autovacuum_vacuum_cost_delay=20 autovacuum_vacuum_scale_factor=0.2 -- 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