In the business IT shop of the near future, open source software will gain equality with proprietary software, but it won’t get there on its own power, said Marten Mickos, CEO of MySQL AB. “From the beginning, we have never been religious about open source. We think it’s the most effective way to produce software, but we’ve always realized that there are vendors that will stay with closed source products. Our users live in the real world where both open source and closed source software have to work together.“
.. you freaking “SCO huggers”
Same here
I love Postgresql. I’ve used it succesfully on a number of projects. However, we’re building a project that does a lot of real-time reporting (it’s critical to the project) and we’ve found that by using MyISAM tables to store the information that we’re reporting on, we get MUCH better performance. Sadly, I’m in he process of moving from Postgres to MySQL 5. I know it’s a step in the wrong direction but we need the performance of non-transactional tables.
Why is moving to something that is going to give you what you need a step in the wrong direction? Surely it’s best to use the right tool for the job?
Unless you are moving completely away from PostgreSQL and you need some of its unique features? In which case I can see your dilemna.
Before the trolls appear: I like both databases.
This is off-topic, but PostgreSQL defaults to much more conservative settings than MySQL, and these can be tweaked considerably. Have you visited http://www.powerpostgresql.com/PerfList/ ?
Good advice. Another thing to do, could be to set the transaction isolation level to something more dangerous than the default.