Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-10-02 Thread Simon Riggs
On Tue, 2009-09-29 at 09:36 +0200, 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. > You can find the article here: > http://suckit.blog.hu/2009/09/26/po

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-30 Thread György Vilmos
2009/9/30 Scott Marlowe > On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith 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 > ben

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-30 Thread György Vilmos
2009/9/30 Greg Smith > 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

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-30 Thread György Vilmos
2009/9/29 Grzegorz Jaśkiewicz > any chance you can test the recent postgresql Cvs-head build (to be 8.5). > > Sadly, no, the machine was not mine and I had to give it back. -- http://suckit.blog.hu/

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-30 Thread György Vilmos
2009/9/29 Amitabh Kant > On Tue, Sep 29, 2009 at 1:06 PM, György Vilmos wrote: > >> Hello, >> >> 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. >> You can find the article h

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-29 Thread Scott Marlowe
On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith 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 fe

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-29 Thread Greg Smith
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

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-29 Thread Amitabh Kant
On Tue, Sep 29, 2009 at 1:06 PM, György Vilmos wrote: > Hello, > > 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. > You can find the article here: > http://suckit.blog.hu/2009/

Re: [GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-29 Thread Grzegorz Jaśkiewicz
any chance you can test the recent postgresql Cvs-head build (to be 8.5).

[GENERAL] Performance evaluation of PostgreSQL's historic releases

2009-09-29 Thread György Vilmos
Hello, 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. You can find the article here: http://suckit.blog.hu/2009/09/26/postgresql_history Thanks for working on this great piece of