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
> "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
> "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
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
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
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
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
> "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.