Re: Performance evaluation of PostgreSQL's historic releases

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.