I'm planning to move one of my development database servers to its own machine. I'm currently running it on my laptop, which is not very convenient.
- DB Servel is PostgreSQL 9.0.1,
- OS is Gentoo.
There is only one development server attached to the db, so there's not many queries. The problem is the amount of data: I need to store a copy of planet.osm, which is over 170 Gb at the moment, and increasing.
I'm looking for a solution that doesn't require me to buy expensive hardware, as this is not a production server anyway. I might even be able to reuse some low-end machines I have, with the only exception being their hard drive.
So my question is, what kind of hard drive should I be looking for?
I am currently using a relatively cheap 1.5 Tb external USB drive with a single
btrfs partition on it, but I'm not sure that would be fast enough for a db server to find a needle in a 170+ Gb haystack on it.
What tools can I use to measure hdd performance on Linux?
Note that this question is somewhat related to this one, with the main difference being I'm not building a production server.