Message-ID: <4D4332F5.8050503@missouri.edu>
Date: Fri, 28 Jan 2011 15:19:49 -0600
From: Robert Schnabel <schnabelr@missouri.edu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US;
	rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
To: Stephen Frost <sfrost@snowman.net>
CC: "david@lang.hm" <david@lang.hm>,
	pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: How to best use 32 15k.7 300GB drives?
References: <4D41F92F.9030006@missouri.edu>
	<alpine.DEB.2.00.1101271512390.17579@asgard.lang.hm>
	<4D420D61.3000109@missouri.edu>
	<20110128131410.GC30352@tamriel.snowman.net>
	<4D42F127.9050307@missouri.edu>
	<20110128171411.GD30352@tamriel.snowman.net>
In-Reply-To: <20110128171411.GD30352@tamriel.snowman.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


On 1/28/2011 11:14 AM, Stephen Frost wrote:

>>     It got lost from the original post but my database (9.0.0) is currently on
>>     my Windows XP 64-bit workstation in my office on a 16 drive Seagate 15k.5
>>     RAID5, no comments needed, I know, I'm moving it :-).  I'm moving it to my
>>     server which is Windows Ent Server 2008 R2 64-bit 8 AMD cores&  32G ram
>>     and these new drives/controller.
> Ughh...  No chance to get a Unix-based system (Linux, BSD, whatever) on
> there instead?  I really don't think Windows Server is going to help
> your situation one bit.. :(
>
Almost zero chance.  I basically admin the server myself so I can do 
whatever I want but all permissions are controlled through campus active 
directory and our departmental IT person doesn't do *nix.  So let's just 
assume I'm stuck with Windows. The main purpose of the server at the 
moment is to house our backup images.  I have two 9 TB arrays which I 
use robocopy to mirror images once a day between our other server and my 
workstation.  There's really not much of anything else ever eating up 
CPUs on the server which is why I'm moving my database onto it.

>>     I appreciate the comments thus far.
> Let's hope you'll always appreciate them. :)
>
> 	Thanks,
>
> 		Stephen
Umm, that didn't quite read the way I meant it to when I wrote it.  All 
comments are appreciated.  :-)

Seriously though, there have been points made that have made me rethink 
how I go about processing data which I'm sure will help.  I'm in a 
fairly fortunate position in that I can put these new drives on the 
server and play around with different configurations while I maintain my 
current setup on my workstation.  I guess I just need to experiment and 
see what works.

Thanks again,
Bob