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

Re: Performance evaluation of PostgreSQL's historic releases

From: György Vilmos <vilmos(dot)gyorgy(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance evaluation of PostgreSQL's historic releases
Date: 2009-09-30 18:16:48
Message-ID: dac6660e0909301116x402ffc7ahfed37ee4462b5421@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
2009/9/30 Greg Smith <gsmith(at)gregsmith(dot)com>

> On Tue, 29 Sep 2009, Gy?rgy Vilmos wrote:
>
>  I've done a benchmark of recent versions of PostgreSQL's last five major
>> releases to see, how performance has changed during the past years from
>> version to version.
>>
>
> Your comments suggest V8.4 moves backwards as far as performance goes,
> which is a bit misleading.  A more fair characterization would be to
> disclaim 8.4 as potentially being slower on the very simple benchmarks you
> ran, not necessarily in general.
>
> What actually happened is some features were retuned to give better results
> on difficult queries (increasing default_statistics_target is the main
> example there), and one of the major maintenance tasks was removed
> (adjusting the max_fsm_* parameters).  These and the other 8.4 changes that
> touched performance added a small amount of overhead for simple queries, but
> in the situations where they help the gain can be big.
>
> Had you instead benchmarked a complicated query where the statistics change
> caused the default behavior to provide better query plans, or you had a
> deletion-heavy workload where 8.3 had trouble maintaining database free
> space, you could have seen significantly better performance on 8.4. The
> improvements in that version just don't help trivial examples like the
> sysbench ones you ran.
>
> P.S. On your write-heavy tests, increasing checkpoint_segments a lot should
> improve overall performance, if you re-test at some point.
>
Thank you very much for the valuable comments, I will keep them in mind for
the next test.

BTW, this wasn't a "how could I get the maximum out of PostgreSQL", that
would need much more time and research (or inner knowledge about the
program).

-- 
http://suckit.blog.hu/

In response to

pgsql-general by date

Next:From: György VilmosDate: 2009-09-30 18:21:54
Subject: Re: Performance evaluation of PostgreSQL's historic releases
Previous:From: György VilmosDate: 2009-09-30 18:12:58
Subject: Re: Performance evaluation of PostgreSQL's historic releases

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