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] New hardware thoughts

2006-10-20 Thread Ben Suffolk
Yes I am looking at either the 2950 or the 6850. I think the only think that the 6850 really offers me over the 2950 is more expandability in the spare processor, and additional memory I see (in first mail) you plan to use bsd 6.1 on dell2950. --- flame on Off topic for postgresql performance

Re: [PERFORM] New hardware thoughts

2006-10-20 Thread Ben Suffolk
You mentioned a "Perc" controller, so I'll assume this is a Dell. My advice is to find another supplier. check the archives for Dell. Basically you have no idea what the Perc controller is since it is whatever Dell decides to ship that day. In general though you are going down the right path

Re: [PERFORM] New hardware thoughts

2006-10-20 Thread Ben Suffolk
Cheers Shane, Sounds like you have a very good idea of what to expect. Are these solid stats or certain estimates? Estimates can vary when it comes time to start. The figures all come from how my application interacts with the database when an event happens, so the scaling of operations t

[PERFORM] New hardware thoughts

2006-10-20 Thread Ben Suffolk
Hello all, I am currently working out the best type of machine for a high volume pgsql database that I going to need for a project. I will be purchasing a new server specifically for the database, and it won't be running any other applications. I will be using FreeBSD 6.1 Stable. I think