Re: Speed / Server

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: Speed / Server
Дата
Msg-id d4e11e980910050630h1324ee6dq8d60608997850b69@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Speed / Server  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Speed / Server  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance

But you should plan on partitioning to multiple db servers up front
and save pain of conversion later on.  A dual socket motherboard with
16 to 32 SAS drives and a fast RAID controller is WAY cheaper than a
similar machine with 4 to 8 sockets is gonna be.  And if you gotta go
there anyway, might as well spend your money on other stuff.


I agree.  If you can partition that sensor data across multiple DBs and have your application do the knitting you might be better off.  If I may be so bold, you might want to look at splaying the systems out across your backends.  I'm just trying to think of a dimension that you won't want to aggregate across frequently.

On the other hand, one of these 16 to 32 SAS drive systems with a raid card will likely get you a long way.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Best suiting OS
Следующее
От: Jean-David Beyer
Дата:
Сообщение: Re: Best suiting OS