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 throughput on quad Opteron

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 use

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

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

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 you sling the

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

[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

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 (throw in

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