… in MySQL. For example PostgreSQL is slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
I had found pile of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. … about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie SubQueries avoided for MySQL) so…
Comment: Which adaptive should we use?
September 16, 2009 By 14 Comments
…_flush_method What you say is feature for PostgreSQL only…. Do you prefer PostgreSQL to MySQL??? 
(PostgreSQL is one of the RDBMS which has… of performance for me. I think you should not tune MySQL/InnoDB based on the PostgreSQL tuning knowledge…) Thank you
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… MySQL and PostgreSQL with different CPUs. I was in contact with Tweakers.net team to see if they miss something obvious in MySQL… of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8.2 results Same as in previous test PostgreSQL is winner with large margin especially when it comes to higher concurrency. The results for MySQL 5.0…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… other OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there are plugable storage engines (something even PostgreSQL does not have… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Comment: Guidance for MySQL Optimizer Developers
September 23, 2009 By 4 Comments
I cannot agree more. Some database projects (for instance PostgreSQL) have the following policy: if the optimizer is wrong, then …. I will not comment on the relative quality of Oracle/MySQL/PostgreSQL query optimizer. My point is it is not really a…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the… to be more. Finally, PostgreSQL is clearly better for some workloads out-of-the-box than MySQL is, especially for more complex…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as… for MySQL as they use for PostgreSQL for example instead of investing time to learn about MySQL Replication or just looking to keep MySQL… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: MySQL Community Dinner
April 14, 2008 By Leave a Comment
…. It was great to have a chat with bunch of MySQL and MySQL Community guys, in particular with Mark Callaghan from Google about his experiences of using MySQL and work he does to scale MySQL and make it Highly Available. One of… me to hear Marten Mickos is also now responsible for PostgreSQL efforts inside of Sun. I do not think this makes…
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
… there were few MySQL Developers hanging around it most of the time, compared to army of technical guys at PostgreSQL booth. I would say even SolidDB booth was more attended. I’ve heard comments from some MySQL people this… they know they need to know about MySQL already and nothing cool happened from MySQL Users Conference ? In general my impression PostgreeSQL…
