10K vs 15k rpm for analytics

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема 10K vs 15k rpm for analytics
Дата
Msg-id cone.1267562557.293175.32557.1000@shelca
обсуждение исходный текст
Ответы Re: 10K vs 15k rpm for analytics  (Yeb Havinga <yebhavinga@gmail.com>)
Re: 10K vs 15k rpm for analytics  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: 10K vs 15k rpm for analytics  (david@lang.hm)
Re: 10K vs 15k rpm for analytics  (Greg Smith <greg@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: No hash join across partitioned tables?
Следующее
От: Yeb Havinga
Дата:
Сообщение: Re: 10K vs 15k rpm for analytics