2009/9/30 Scott Marlowe <scott.marl...@gmail.com> > On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsm...@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... -- http://suckit.blog.hu/