From: Francisco Reyes <lists@stringsutils.com>
To: Pgsql performance <pgsql-performance@postgresql.org>
Subject: 10K vs 15k rpm for analytics
Date: Tue, 02 Mar 2010 15:42:37 -0500
Message-ID: <cone.1267562557.293175.32557.1000@shelca> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@stringsutils.com
Subject: Re: 10K vs 15k rpm for analytics
In-Reply-To: <cone.1267562557.293175.32557.1000@shelca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox