Seconded .... these days even a single 5400rpm SATA drive can muster almost 100MB/sec on a sequential read.
The benefit of 15K rpm drives is seen when you have a lot of small, random accesses from a working set that is too big to cache .... the extra rotational speed translates to an average reduction of about 1ms on a random seek and read from the media.
Cheers
Dave
On Tue, Mar 2, 2010 at 2:51 PM, Yeb Havinga
<yebhavinga@gmail.com> wrote:
Francisco Reyes wrote:
Anyone has any experience doing analytics with postgres. In particular if 10K rpm drives are good enough vs using 15K rpm, over 24 drives. Price difference is $3,000.
Rarely ever have more than 2 or 3 connections to the machine.
So far from what I have seen throughput is more important than TPS for the queries we do. Usually we end up doing sequential scans to do summaries/aggregates.
regards,
Yeb Havinga