Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-24 Thread Bucky Jordan
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-performance- > [EMAIL PROTECTED] On Behalf Of John Philips > Sent: Monday, October 23, 2006 8:17 AM > To: Ben Suffolk > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Optimizing disk throu

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread Jim C. Nasby
On Sat, Oct 21, 2006 at 08:43:05AM -0700, John Philips wrote: > I heard some say that the transaction log should be on > it's own array, others say it doesn't hurt to have it > on the same array as the OS. Is it really worthwhile > to put it on it's own array? It all depends on the controller and

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread Joshua D. Drake
Vivek Khera wrote: > > On Oct 23, 2006, at 4:59 PM, Joshua D. Drake wrote: > >>> If I had $50k budget, I'd be buying the SunFire X4500 and running >>> Solaris + ZFS on it. However, you're limited to 2 dual core Opterons, >>> it seems. >> >> The HP 585 will give you quad dual core :) > > but can

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread Vivek Khera
On Oct 23, 2006, at 4:59 PM, Joshua D. Drake wrote: If I had $50k budget, I'd be buying the SunFire X4500 and running Solaris + ZFS on it. However, you're limited to 2 dual core Opterons, it seems. The HP 585 will give you quad dual core :) but can you sling the bits to and from the dis

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread Joshua D. Drake
Vivek Khera wrote: > > On Oct 21, 2006, at 11:43 AM, John Philips wrote: > >> Can you guys see any glaring bottlenecks in my layout? >> Any other suggestions to offer (throw in more >> controllers, different RAID layout, etc.)? Our budget >> limit is $50k. > > If I had $50k budget, I'd be buyi

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread Vivek Khera
On Oct 21, 2006, at 11:43 AM, John Philips wrote: Can you guys see any glaring bottlenecks in my layout? Any other suggestions to offer (throw in more controllers, different RAID layout, etc.)? Our budget limit is $50k. If I had $50k budget, I'd be buying the SunFire X4500 and running Sol

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-23 Thread John Philips
> The thing I would ask is would you not be better > with SAS drives? > > Since the comments on Dell, and the highlighted > issues I have been > looking at HP and the the Smart Array P600 > controller with 512 BBWC. > Although I am looking to stick with the 8 internal > disks, rather than >

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-21 Thread Ben Suffolk
You can find a diagram of my initial spec here: http://img266.imageshack.us/img266/9171/dbserverdiagramuc3.jpg Can you guys see any glaring bottlenecks in my layout? Any other suggestions to offer (throw in more controllers, different RAID layout, etc.)? Our budget limit is $50k. The thing I

Re: [PERFORM] Optimizing disk throughput on quad Opteron

2006-10-21 Thread Joshua D. Drake
> I heard some say that the transaction log should be on > it's own array, others say it doesn't hurt to have it > on the same array as the OS. Is it really worthwhile > to put it on it's own array? > > Can you guys see any glaring bottlenecks in my layout? > Any other suggestions to offer (thr

[PERFORM] Optimizing disk throughput on quad Opteron

2006-10-21 Thread John Philips
Hello, I'm working out specs for a new database server to be purchased for our organization. The applications the server will handle are mainly related to network operations (monitoring, logging, statistical/trend reports, etc.). Disk I/O will be especially high with relation to processing netwo