I am working with a postgresql database that sits on really old Hardware.
1 Sun Sunfire V60x with a single 3.0ghx Xeon FSB 400 512kb cache with 6gb of RAM running RHEL 4 (32bit)
The table space and logs are stored in the same 250gb LUN on a Hitach 9520v SAN running with 8 10k RPM USCSI drives with 146gb each.
Our budget is tight and given the performance advance of modern HDD's and cheap RAM I wonder how many new 15k RPM drives it would take to offer the same performance.
The table space is around 80 GB and our workload is probably 90% read and 10% write as the RDMS holds our organizations registry and is [almost] only used for reporting.
Edit: We will be using a brand new server with 2x Xeon 5620s and 32gb of RAM. I wonder if I can avoid the expense of the SAN.