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.