Re: [GENERAL] disk performance benchmarks

2004-09-15 Thread Ron St-Pierre
oops, sent this to performance by mistake. Jeffrey W. Baker wrote: All these replies are really interesting, but the point is not that my RAIDs are too slow, or that my CPUs are too slow. My point is that, for long stretches of time, by database doesn't come anywhere near using the capacity of the

Re: [GENERAL] disk performance benchmarks

2004-09-15 Thread Vivek Khera
> "JWB" == Jeffrey W Baker <[EMAIL PROTECTED]> writes: JWB> All these replies are really interesting, but the point is not that my JWB> RAIDs are too slow, or that my CPUs are too slow. My point is that, for JWB> long stretches of time, by database doesn't come anywhere near using the JWB> ca

Re: [GENERAL] disk performance benchmarks

2004-09-15 Thread Vivek Khera
> "GS" == Greg Stark <[EMAIL PROTECTED]> writes: GS> For write heavy application I would expect RAID5 to be a lose on GS> any software-raid based solution. Only with good hardware raid GS> systems with very large battery-backed cache would it begin to be GS> effective. Who in their right mind

Re: [GENERAL] disk performance benchmarks

2004-09-15 Thread Jeffrey W. Baker
On Wed, 2004-09-15 at 02:39, Michael Paesold wrote: > Jeffrey W. Baker wrote: > > > Current issue: > > > > A dual 64-bit Opteron 244 machine with 8GB main memory, two 4-disk RAID5 > > arrays (one for database, one for xlogs). PG's config is extremely > > generous, and in isolated benchmarks it's

Re: [GENERAL] disk performance benchmarks

2004-09-14 Thread Jeffrey W. Baker
On Tue, 2004-09-14 at 14:45, Jim C. Nasby wrote: > On Tue, Sep 14, 2004 at 11:11:38AM -0700, Jeffrey W. Baker wrote: > > procs ---memory-- ---swap-- -io --system-- cpu > > r b swpd free buff cache si sobibo incs us sy id wa > > 3 0216

Re: [GENERAL] disk performance benchmarks

2004-09-14 Thread Jim C. Nasby
On Tue, Sep 14, 2004 at 11:11:38AM -0700, Jeffrey W. Baker wrote: > procs ---memory-- ---swap-- -io --system-- cpu > r b swpd free buff cache si sobibo incs us sy id wa > 3 0216 13852 39656 773972400 820 2664 2868 2557 1

Re: [GENERAL] disk performance benchmarks

2004-09-14 Thread Jeffrey W. Baker
On Tue, 2004-09-14 at 10:28, Vivek Khera wrote: > > "SW" == Shane Wright writes: > > SW> But, we have now taken the plunge and I'm in a position to do some > SW> benchmarking to actually get some data. Basically I was wondering if > SW> anyone else had any particular recommendations (or requ

Re: [GENERAL] disk performance benchmarks

2004-09-14 Thread Vivek Khera
> "SW" == Shane Wright writes: SW> But, we have now taken the plunge and I'm in a position to do some SW> benchmarking to actually get some data. Basically I was wondering if SW> anyone else had any particular recommendations (or requests) about the SW> most useful kinds of benchmarks to do.