MPB: Comparison of MyISAM Infobright and MonetDB

This post is originally created by Baron Schwartz at MPB (A.k.a. MySQLPerformanceBlog.com) days ago. What follows is not a realistic benchmark, it’s not scientific, it’s just some quick and dirty tinkering. Baron threw up an Ubuntu 9.04 small server on Amazon. (Because there’s a .deb of MonetDB for it), and created a table with 200 […]
Continue reading…

 

Performance Tuning PostgreSQL

PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can’t. The problem is that every database is not only different in its design, but also its requirements. Some […]
Continue reading…