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.
In response to
pgsql-general by date
|Next:||From: Sam Mason||Date: 2009-09-29 23:16:48|
|Subject: Re: bulk inserts|
|Previous:||From: Greg Smith||Date: 2009-09-29 22:59:32|
|Subject: Re: pitr errors|