Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2D9062E0035 for ; Wed, 21 Nov 2007 21:26:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20594-08 for ; Wed, 21 Nov 2007 21:26:44 -0400 (AST) Received: from mail15.syd.optusnet.com.au (mail15.syd.optusnet.com.au [211.29.132.196]) by postgresql.org (Postfix) with ESMTP id C76302E0033 for ; Wed, 21 Nov 2007 21:26:44 -0400 (AST) Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227]) (authenticated sender plengada@optusnet.com.au) by mail15.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id lAM1QX2t011047 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 22 Nov 2007 12:26:39 +1100 Message-ID: <4744DA39.2030301@reynolds.com.au> Date: Thu, 22 Nov 2007 10:24:09 +0900 From: Paul Lambert User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql admin Subject: Re: New server configuration References: <4744C9C6.9060902@reynolds.com.au> In-Reply-To: <4744C9C6.9060902@reynolds.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/189 X-Sequence-Number: 27432 Paul Lambert wrote: > I've got a new server which I'm looking for some assistance on > determining the best configuration for PostgreSQL. It's the first time > I've had to set up a new PG server from scratch and it has very > different specs to our other servers which I don't think were properly > tuned anyway. > > The basic server specs are as follows: > CPU: Pentium Xeon Quad-core 1.6GHz > RAM: 4Gb 633MHz DDR > HDD: 6*146Gb SAS drives in 3*146GB RAID-1 sets. > > The database will have one process running that collects data from > various external sources and pipes it into the database via a single > connection. These udpates can be as few as one every couple of minutes > or as many as 50-100 per second depending on the time of day. > > A number of users will connect at various times of day with a reporting > tool such as Microsoft Access, Crystal Reports, and some of our own > in-house things pulling at times large chunks of data out, at other > times smaller chunks. > > The server will be dedicated to running PostgreSQL with a few smaller > apps that take up next to no CPU/Memory/Disk. > > At the moment I've got the disks arranged with 1 for software, 1 for > data and 1 for transaction logs/WAL. > > I'm curious to know what some might suggest are the best settings for > resource usage (shared buffers, maintenance_work_mem etc) WAL and > autovacuum - I can dedicate basically as much of the system resources to > PG as it would need for best performance. > > TIA, > > P. > Should have mentioned the O/S is Windows Server 2003 *don't kill me :(* -- Paul Lambert Database Administrator AutoLedgers - A Reynolds & Reynolds Company