On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsmith@gregsmith.com> wrote: > P.S. On your write-heavy tests, increasing checkpoint_segments a lot should > improve overall performance, if you re-test at some point.
Just wanted to add that in order to really test a db, you need a benchmark that runs a lot longer than a few minutes. I routinely use tests that run for hours to get an idea how things like write ahead logging and such affect the db under heavy, long term load.
Agreed, but even with 5x1 minutes of test runs for each threads it took a week to do all the tests.
I've once heard that a company have spent three man years for performance testing one of its products...
