|

»

freebsd-performance

Performance evaluation of PostgreSQL's historic releases

View: New views

7 Messages — Rating Filter: Alert me

	Performance evaluation of PostgreSQL's historic releases by György Vilmos :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, 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 The tests were conducted on FreeBSD 8/amd64 on a midrange x86 server (4 CPUs, 24 cores, 128GiB RAM). -- http://suckit.blog.hu/ _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by Attilio Rao-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/9/29 György Vilmos <vilmos.gyorgy@...>: > Hi, > > 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 > > The tests were conducted on FreeBSD 8/amd64 on a midrange x86 server (4 > CPUs, 24 cores, 128GiB RAM). Do you have informations about the systime when doing such tests? Attilio -- Peace can only be achieved by understanding - A. Einstein _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by Francisco Reyes-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message György Vilmos writes: > 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. Thanks! Very interesting. Did you share it with the Postgresql list yet? I think they would find it very interesting. Any plans on doing simmilar tests with data that does not fit in memory? Also could you share what settings were used for postgres? Where any defaults changed? Effective memory, shared_buffers, etc... any of them adjusted for the machine's memory? _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by György Vilmos :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, 2009/9/29 Attilio Rao <attilio@...> > 2009/9/29 György Vilmos <vilmos.gyorgy@...>: > > Hi, > > > > 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 > > > > The tests were conducted on FreeBSD 8/amd64 on a midrange x86 server (4 > > CPUs, 24 cores, 128GiB RAM). > > Do you have informations about the systime when doing such tests? > I haven't got enough time to do the measurement right, so I could not log that. But according to top there were idle times. BTW, even on one thread, Linux (2.6.31) performs much better, better means here 790 TPS vs. 580... -- http://suckit.blog.hu/ _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by György Vilmos :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/9/29 Francisco Reyes <lists@...> > György Vilmos writes: > > 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. >> > > Thanks! > Very interesting. > Did you share it with the Postgresql list yet? > I think they would find it very interesting. > > Any plans on doing simmilar tests with data that does not fit in memory? > Also could you share what settings were used for postgres? Where any > defaults changed? Effective memory, shared_buffers, etc... any of them > adjusted for the machine's memory? > I've updated the article with the used config. With this machine everything would fit in memory (72G disk versus 128 G RAM :). Of course I could artificially limit it... -- http://suckit.blog.hu/ _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by Francisco Reyes-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message György Vilmos writes: > BTW, even on one thread, Linux (2.6.31) performs much better, better means > here 790 TPS vs. 580... What test did you use to meassure TPS? That is a pretty big difference. _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."
	Re: Performance evaluation of PostgreSQL's historic releases by György Vilmos :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/10/2 Francisco Reyes <lists@...> > György Vilmos writes: > > BTW, even on one thread, Linux (2.6.31) performs much better, better means >> here 790 TPS vs. 580... >> > > What test did you use to meassure TPS? > That is a pretty big difference. > > sysbench -- http://suckit.blog.hu/ _______________________________________________ freebsd-performance@... mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@..."