On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsm...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
