PostgreSQL Server Benchmarks: Part Five — Disks

05 Jul 2011

Over the past few posts I’ve talked a lot about optimizing our new server’s basic systems. The RAM and CPU benchmarking and optimization has been relatively straightforward; the individual subsystems are either fast or they’re not. Our next stop is the disks, and the landscape isn’t quite so simple this time. While there aren’t as many options for the disks as there were for the CPUs, the changes made here make a more substantial impact on the system’s performance. The main bottleneck for any database is I/O, so the goal here is to make sure we’re not leaving any performance on the table.