2009/9/30 Scott Marlowe <scott.marlowe@xxxxxxxxx>
On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsmith@xxxxxxxxxxxxx> wrote:Just wanted to add that in order to really test a db, you need a
> P.S. On your write-heavy tests, increasing checkpoint_segments a lot should
> improve overall performance, if you re-test at some point.
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/
