title: Postgres 9.1 vs Mysql 5.6 InnoDB?
body: <p>Simple question - what would better for a medium/big size database with requirement for compatibility with ACID in 2012.</p>
  
  <p>I have read it all (well most) about mySQL vs pgSQL but most of those posts relate to version 4,5.1 and 7,8 respectively and are quite dated (2008,2009). Its almost 2012 now so I guess we could try and take a fresh look at the issue. </p>
  
  <p>Basically I would like to know if there is anything in PostgreSQL that out-weights ease of use, availability and larger developer/knowledge base of MySQL.</p>
  
  <p>Is MySQL's query optimizer still stupid? Is it still super slow on very complicated queries? </p>
  
  <p>Hit me! :)</p>
  
  <p>PS. And don't send me to goggle or wiki. I am looking for few specific points not an overview + I trust StackOverflow more than some random page with 'smart guy' shining his light.</p>
  
  <p><strong>Addendum</strong></p>
  
  <p><em>Size of the project</em>: Say an ordering system with roughly 10-100 orders/day per account, couple of thousand accounts, eventually, each can have several hundred to several thousand users.</p>
  
  <p><em>Better at</em>: being future proof and flexible when it comes to growing and changing requirements. Performance is also important as to keep costs low in hardware department. Also availability of skilled workforce would be a factor. </p>
  
  <p><em>OLTP or OLAP</em>: OLTP</p>