Re: [GENERAL] Question on Opteron performance

2004-03-15 Thread William Yu
Reece Hart wrote: On Wed, 2004-03-10 at 18:23, William Yu wrote: /At this time, only Newisys offers a Quad Opteron box and it carries a hefty premium. (Sun's upcoming 4X machine is a rebadged Newisys machine and it's possible HP's will be also.)/ There are several vendors with quad opterons out

Re: [GENERAL] Question on Opteron performance

2004-03-12 Thread Reece Hart
On Wed, 2004-03-10 at 18:23, William Yu wrote: At this time, only Newisys offers a Quad Opteron box and it carries a hefty premium. (Sun's upcoming 4X machine is a rebadged Newisys machine and it's possible HP's will be also.) There are several vendors with quad opterons out there. Off the

Re: [GENERAL] Question on Opteron performance

2004-03-11 Thread scott.marlowe
On Wed, 10 Mar 2004, Christopher Petrilli wrote: > On Mar 10, 2004, at 3:14 PM, Steve Wolfe wrote: > > >Before I shell out the $15k on the 4-way Opteron, I'm going to spend > > some long, hard time looking for ways to make the system more > > efficient. > > However, after all that's already

Re: [GENERAL] Question on Opteron performance

2004-03-11 Thread Vivek Khera
> "SW" == Steve Wolfe <[EMAIL PROTECTED]> writes: SW> However, after all that's already been done, I'm not optimistic that it's SW> going to preclude needing the new server. I'm just surprised that nobody SW> seems to have used PostgreSQL on a quad-Opteron before! I think people saturate the

Re: [GENERAL] Question on Opteron performance

2004-03-11 Thread Lincoln Yeoh
With mem per CPU, Opterons scale very well in most cases (as long as you have many processes). The lower memory latency helps too. Is it likely for you to be network bandwidth limited - e.g. maxing out your NICs or NIC I/O capacity? I doubt it, but if you are actually getting close then things

Re: [GENERAL] Question on Opteron performance

2004-03-10 Thread Christopher Petrilli
On Mar 10, 2004, at 3:14 PM, Steve Wolfe wrote: Before I shell out the $15k on the 4-way Opteron, I'm going to spend some long, hard time looking for ways to make the system more efficient. However, after all that's already been done, I'm not optimistic that it's going to preclude needing the

Re: [GENERAL] Question on Opteron performance

2004-03-10 Thread Steve Wolfe
> The only time I've seen high cpu and memory bandwidth load with near-zero i/o > load like you describe was on Oracle and it turned out to be an sql > optimization problem. > What caused it was a moderate but not very large table on which a very > frequent query was doing a full table scan (= seq