Re: Performance evaluation of PostgreSQL's historic releases

2009/9/30 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

> On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsmith(at)gregsmith(dot)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/