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)
Re: 10K vs 15k rpm for analytics  (Scott Marlowe)
Re: 10K vs 15k rpm for analytics  ()
Re: 10K vs 15k rpm for analytics  (Greg Smith)
Список pgsql-performance
Дерево обсуждения
10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Yeb Havinga, )
  Re: 10K vs 15k rpm for analytics  (Greg Smith, )
   Re: 10K vs 15k rpm for analytics  (Yeb Havinga, )
    Re: 10K vs 15k rpm for analytics  ("Pierre C", )
  Re: 10K vs 15k rpm for analytics  (Dave Crooke, )
  Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
   Re: 10K vs 15k rpm for analytics  (Yeb Havinga, )
 Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
 Re: 10K vs 15k rpm for analytics  (, )
  Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
   Re: 10K vs 15k rpm for analytics  (Greg Smith, )
    Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
     Re: 10K vs 15k rpm for analytics  (Greg Smith, )
      Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
       Re: 10K vs 15k rpm for analytics  (Greg Smith, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
  Re: 10K vs 15k rpm for analytics  (Greg Smith, )
  Re: 10K vs 15k rpm for analytics  (Yeb Havinga, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
  Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
   Re: 10K vs 15k rpm for analytics  (, )
    Re: 10K vs 15k rpm for analytics  (Scott Carey, )
     Re: 10K vs 15k rpm for analytics  (Greg Smith, )
      Re: 10K vs 15k rpm for analytics  ("Pierre C", )
       Re: 10K vs 15k rpm for analytics  ("Ing. Marcos Ortiz Valmaseda", )
       Re: 10K vs 15k rpm for analytics  (, )
       Re: 10K vs 15k rpm for analytics  ("Kevin Grittner", )
       Re: 10K vs 15k rpm for analytics  (Michael Stone, )
      Re: 10K vs 15k rpm for analytics  (Scott Carey, )
       Re: 10K vs 15k rpm for analytics  (Scott Carey, )
       Re: 10K vs 15k rpm for analytics  (Greg Smith, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
  Re: 10K vs 15k rpm for analytics  (Scott Carey, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
 Re: 10K vs 15k rpm for analytics  (Greg Smith, )
  Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
  Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
  Re: 10K vs 15k rpm for analytics  (Greg Smith, )
 Re: 10K vs 15k rpm for analytics  (Francisco Reyes, )
  Re: 10K vs 15k rpm for analytics  (Yeb Havinga, )
 Re: 10K vs 15k rpm for analytics  (Scott Marlowe, )
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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: 10K vs 15k rpm for analytics
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: 10K vs 15k rpm for analytics