Skip site navigation (1) Skip section navigation (2)

Re: Performance evaluation of PostgreSQL's historic releases

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: György Vilmos <vilmos(dot)gyorgy(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Performance evaluation of PostgreSQL's historic releases
Date: 2009-09-29 23:03:00
Message-ID: dcc563d10909291603x13fac5bbu3e6731522af79e39@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Sam MasonDate: 2009-09-29 23:16:48
Subject: Re: bulk inserts
Previous:From: Greg SmithDate: 2009-09-29 22:59:32
Subject: Re: pitr errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group