On Wed, May 4, 2011 at 9:48 PM, Austin Clements <amdragon at mit.edu> wrote: > As another data point, with a probably very different configuration (8 > year old P4, new SSD), my test query was 1.9X faster uncached and 1.6X > faster cached. ?It also produced 60% fewer disk reads. ?I saw the same > 1% increase in database size.
Oops, the email was on an SSD, but the database was on a separate spinning disk. With them both on the SSD, it's 2.1X faster uncached.