On Jun 10, 2004, at 12:02 PM, Anjan Dave wrote:
Vivek,
Was there anything specific that helped you decide on a RAID-5 and not
a RAID-10?
performance testing on restore times. My DB is more than 50% write, so
I needed to optimize for writes.
I have my DBs on RAID10, and would soon be moving them
]
Sent: Tue 3/2/2004 4:27 PM
To: Vivek Khera; [EMAIL PROTECTED]
Cc:
Subject: Re: [PERFORM] Database Server Tuning
Vivek,
> I did a bunch of testing with different RAID levels on a 14 disk
> array. I f
Vivek,
> I did a bunch of testing with different RAID levels on a 14 disk
> array. I finally settled on this: RAID5 across 14 disks for the
> data, the OS (including syslog directory) and WAL on a RAID1 pair on
> the other channel of the same controller (I didn't want to spring for
> dual RAID c
Vivek,
> > With large RAID, have you found that having WAL on a seperate array
> > actually
> > boosts performance? The empirical tests we've seen so far don't seem
> > to
> > support this.
>
> Yes, it was a noticeable improvement.
Do you have any stats? This would be useful for your talk,
On Mar 2, 2004, at 4:27 PM, Josh Berkus wrote:
Vivek,
I did a bunch of testing with different RAID levels on a 14 disk
array. I finally settled on this: RAID5 across 14 disks for the
data, the OS (including syslog directory) and WAL on a RAID1 pair on
the other channel of the same controller (I
> "JA" == John Allgood <[EMAIL PROTECTED]> writes:
JA> I am planning on separating the OS, Data, WAL on to separate drives
JA> which will be mirrored. I am looking for input on setting kernel parameters,
JA> and Postgres server runtime parameters and other settings relating to
I did a bun
On Thu, 26 Feb 2004 16:28:07 -0500, John Allgood wrote:
> I am planning on separating the OS, Data, WAL on to separate drives
> which will be mirrored.
Have you considered RAID-10 in stead of RAID-1?
> I am looking for input on setting kernel
> parameters, and Postgres server runtime param
John,
> and Postgres server runtime parameters and other settings relating to
> tuning. Also is there any benchmarking tools available that will help me
> tune this server.
Check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Also, I'd like to see what you get under heavy load
Josh Berkus wrote:
John,
and Postgres server runtime parameters and other settings relating to
tuning. Also is there any benchmarking tools available that will help me
tune this server.
Check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Also, I'd like to see what you