10K vs 15k rpm for analytics - Mailing list pgsql-performance

From Francisco Reyes
Subject 10K vs 15k rpm for analytics
Date
Msg-id cone.1267562557.293175.32557.1000@shelca
Whole thread Raw
Responses Re: 10K vs 15k rpm for analytics
Re: 10K vs 15k rpm for analytics
Re: 10K vs 15k rpm for analytics
Re: 10K vs 15k rpm for analytics
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: No hash join across partitioned tables?
Next
From: Yeb Havinga
Date:
Subject: Re: 10K vs 15k rpm for analytics