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 615-26

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 > y

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

2005-04-06 Thread PFC
and we get about 65MB/sec sustained when writing to an ext3 filesystem (actually, when wgetting a file off the gigabit LAN :-) ). I haven't 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 networ

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-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 pick

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 1

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 w

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

2005-03-31 Thread Steve Poe
Thanks for everyone's feedback on to best improve our Postgresql database for the animal hospital. I re-read the PostgreSQL 8.0 Performance Checklist just to keep focused. We purchased (2) 4 x 146GB 10,000rpm SCSI U320 SCA drive arrays ($2600) and (1) Sun W2100z dual AMD64 workstation with 4GB