Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Arjen van der Meijden
On 20-10-2006 22:33 Ben Suffolk wrote: How about the Fujitsu Siemens Sun Clones? I have not really looked at them but have heard the odd good thing about them. Fujitsu doesn't build Sun clones! That really is insulting for them ;-) They do offer Sparc-hardware, but that's a bit higher up the

Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Bucky Jordan
-logic raid-controller) and found it to be a very nice machine. But again, they also offer (the same?) Broadcom networking on board. Just like Dell and HP. And it is a LSI Logic sas-controller on board, so if FBSD has trouble with either of those, its hard to find anything suitable at all in

Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Vivek Khera
On Oct 20, 2006, at 10:58 AM, Dave Cramer wrote: My advice is to find another supplier. check the archives for Dell. Not necessarily bad to go with Dell. There are *some* of their controllers that are wicked fast in some configurations. However, finding which ones are fast is very

Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Joshua D. Drake
FUD!!! They don't randomly change the controllers under the same name. If you order a PERC4e/Si controller you will get the same controller every time. Actually Vivek this isn't true. Yes the hardware will likely be the same, but the firmware rev will likely be different and I have seen

Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Joshua D. Drake
Vivek Khera wrote: On Oct 23, 2006, at 5:08 PM, Joshua D. Drake wrote: They don't randomly change the controllers under the same name. If you order a PERC4e/Si controller you will get the same controller every time. Actually Vivek this isn't true. Yes the hardware will likely be the

Re: [PERFORM] New hardware thoughts

2006-10-23 Thread Jim C. Nasby
On Sat, Oct 21, 2006 at 12:12:59AM +0930, Shane Ambler wrote: Generally more disks at slower speed - 2 10K disks in raid 0 is faster than 1 15K disk. More disks also allow more options. Not at writing they're not (unless you're using RAID0... ugh). -- Jim Nasby

Re: [PERFORM] New hardware thoughts

2006-10-22 Thread Bucky Jordan
-Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-performance- [EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent: Friday, October 20, 2006 2:52 PM To: Ben Suffolk Cc: Dave Cramer; pgsql-performance@postgresql.org Subject: Re: [PERFORM] New hardware thoughts Ben Suffolk

Re: [PERFORM] New hardware thoughts

2006-10-22 Thread Arjen van der Meijden
On 20-10-2006 16:58 Dave Cramer wrote: Ben, My option in disks is either 5 x 15K rpm disks or 8 x 10K rpm disks (all SAS), or if I pick a different server I can have 6 x 15K rpm or 8 x 10K rpm (again SAS). In each case controlled by a PERC 5/i (which I think is an LSI Mega Raid SAS 8408E

Re: [PERFORM] New hardware thoughts

2006-10-22 Thread Joshua D. Drake
If I get the offshelf LSI Megaraid withe the same configuration? You don't want to know... it will just make you want to cry at the fact that you bought a Dell. I agree there's better platforms out there than Dell, but the above is simply not true for the 2950. Raid 5, dd, on 6 disks, I get

Re: [PERFORM] New hardware thoughts

2006-10-20 Thread Shane Ambler
Ben Suffolk wrote: 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

Re: [PERFORM] New hardware thoughts

2006-10-20 Thread Dave Cramer
Ben, On 20-Oct-06, at 3:49 AM, Ben Suffolk wrote: 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

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

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 Joshua D. Drake
Ben Suffolk wrote: 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

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 alvis
Hi Ben , 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