New answers tagged database-performance
Innodb (and in turn xtradb) do not keep running counts of the number of rows in a table. The number of rows displayed when doing a SHOW TABLE STATUS is purely an estimate. Likely your tool wth the progress indicator is using this information to determine what 100% is. Since it's an estimate, so is the percentage complete. This article on stackoverflow ...
I would recommend a pair of Samsung 840 SSDs in RAID-10. You will need to tweak Postgresql to get best performance, but for small random reads you should expect a performance boost of something like 15x compared to a hard drive.
Top 50 recent answers are included