From: Jim C. Nasby <jnasby@pervasive.com>
To: Ron <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sane configuration options for a WinXP laptop 8.1 install?
Date: Thu, 9 Feb 2006 00:32:35 -0600
Message-ID: <20060209063235.GZ57845@pervasive.com> (raw)
In-Reply-To: <7.0.1.0.2.20060208164655.0382eb40@earthlink.net>
References: <7.0.1.0.2.20060208164655.0382eb40@earthlink.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, rjpeace@earthlink.net
Subject: Re: Sane configuration options for a WinXP laptop 8.1 install?
In-Reply-To: <20060209063235.GZ57845@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox