> 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.
