Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-06 Thread Steinar H. Gunderson
On Tue, Apr 05, 2005 at 09:44:56PM -0700, Kevin Brown wrote: Now, the performance is pretty bad considering the setup -- a RAID 5 with five 73.6 gig SCSI disks (10K RPM, I believe). Reads through the filesystem come through at about 65 megabytes/sec, writes about 35 megabytes/sec (at least,

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-06 Thread Steinar H. Gunderson
On Wed, Apr 06, 2005 at 03:26:33PM +0200, PFC wrote: Well, unless you have PCI 64 bits, the standard PCI does 133 MB/s which is then split exactly in two times 66.5 MB/s for 1) reading from the PCI network card and 2) writing to the PCI harddisk controller. No wonder you

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-06 Thread Thomas F . O'Connell
Things might've changed somewhat over the past year, but this is from _the_ Linux guy at Dell... -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source Open Your i http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-05 Thread Kevin Brown
Thomas F.O'Connell wrote: I'd use two of your drives to create a mirrored partition where pg_xlog resides separate from the actual data. RAID 10 is probably appropriate for the remaining drives. Fortunately, you're not using Dell, so you don't have to worry about the Perc3/Di RAID

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-02 Thread Will LaShell
Vivek Khera wrote: On Mar 31, 2005, at 9:01 PM, Steve Poe wrote: Now, we need to purchase a good U320 RAID card now. Any suggestions for those which run well under Linux? Not sure if it works with linux, but under FreeBSD 5, the LSI MegaRAID cards are well supported. You should be able to

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-01 Thread Thomas F.O'Connell
I'd use two of your drives to create a mirrored partition where pg_xlog resides separate from the actual data. RAID 10 is probably appropriate for the remaining drives. Fortunately, you're not using Dell, so you don't have to worry about the Perc3/Di RAID controller, which is not so compatible

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-01 Thread Vivek Khera
On Mar 31, 2005, at 9:01 PM, Steve Poe wrote: Now, we need to purchase a good U320 RAID card now. Any suggestions for those which run well under Linux? Not sure if it works with linux, but under FreeBSD 5, the LSI MegaRAID cards are well supported. You should be able to pick up a 320-2X with