Re: [PERFORM] Help specifying new machine

2004-08-19 Thread Josh Berkus
Tom, > This is really interesting. We had previously seen some evidence that > the Xeon sucks at running Postgres, but I thought that the issues only > materialized with multiple CPUs (because what we were concerned about > was the cost of transferring cache lines across CPUs). AFAICS this test

Re: [PERFORM] Help specifying new machine

2004-08-18 Thread Tom Lane
William Yu <[EMAIL PROTECTED]> writes: > In terms of Postgres database performance, Opteron *may* be the better > CPU for this app but there's not enough data points yet. Here's a recent > review at Anandtech showing Opteron 150 (2.4ghz) versus 64-bit Prescott > 3.6hgz with some very simple MySQ

Re: [PERFORM] Help specifying new machine

2004-08-18 Thread William Yu
Raoul Buzziol wrote: I looked for some benchmarks, and I would know if I'm right on: - Dual Opteron 246 have aproximately the same performance of a Dual Xeon 3Gh (Opteron a little better) - Opteron system equal or cheeper than Xeon system. In terms of general database performance, top of the line d

Re: [PERFORM] Help specifying new machine

2004-08-18 Thread Rod Taylor
On Wed, 2004-08-18 at 11:18, Raoul Buzziol wrote: > > You're not going to be able to get a Dual Athlon MP for the same price > > as a single Xeon. A few years back, this was the case because Xeon CPUs > > & MBs had a huge premium over Athlon. This is no longer true mainly > > because the number of

Re: [PERFORM] Help specifying new machine

2004-08-18 Thread Raoul Buzziol
> You're not going to be able to get a Dual Athlon MP for the same price > as a single Xeon. A few years back, this was the case because Xeon CPUs > & MBs had a huge premium over Athlon. This is no longer true mainly > because the number of people carrying Athlon MP motherboards has dropped > down

Re: [PERFORM] Help specifying new machine

2004-08-15 Thread William Yu
You're not getting much of a bump with this server. The CPU is incrementally faster -- in the absolutely best case scenario where your queries are 100% cpu-bound, that's about ~25%-30% faster. What about using Dual Athlon MP instead of a Xeon? Would be much less expensive, but have higher performa

Re: [PERFORM] Help specifying new machine

2004-08-13 Thread Raoul Buzziol
William Yu wrote: > Rory Campbell-Lange wrote: > >> The present server is a 2GHz Pentium 4/512 KB cache with 2 >> software-raided ide disks (Maxtors) and 1GB of RAM. >> >> >> I have been offered the following 1U server which I can just about >> afford: >> >> 1U server >> Intel Xeon 2.8GHz 512K

Re: [PERFORM] Help specifying new machine

2004-08-12 Thread William Yu
Rory Campbell-Lange wrote: The present server is a 2GHz Pentium 4/512 KB cache with 2 software-raided ide disks (Maxtors) and 1GB of RAM. I have been offered the following 1U server which I can just about afford: 1U server Intel Xeon 2.8GHz 512K cache 1 512MB PC2100 DDR ECC Reg

Re: [PERFORM] Help specifying new machine

2004-08-09 Thread Bill Montgomery
Rory, Rory Campbell-Lange wrote: I'm thinking of upgrading an existing dedicated server and colocating my own server. The server is used for prototype systems running Postgresql, php and apache. The largest database is presently under 10GB and I haven't had any major performance problems. We expect

[PERFORM] Help specifying new machine

2004-08-09 Thread Rory Campbell-Lange
I'm thinking of upgrading an existing dedicated server and colocating my own server. The server is used for prototype systems running Postgresql, php and apache. The largest database is presently under 10GB and I haven't had any major performance problems. We expect to have to host larger data set