![]() Not to mention all the crazy NULL/empty string/ bullshit that mysql can do to your data (even though it has improved a bit with strict mode etc). That's just one example of how much safer it is to use. One important feature difference is that in postgres you can do schema changes inside transactions. And it's been a lot of fun learning and using the extra features - I actually got more excited about using postgres than I have with anything else programming related recently. I wish I'd just got on with trying postgres sooner, because even as someone who used and knew mysql very well for 16 years, it was immediately obvious to me that switching to postgres was the right choice. I put a heap of time researching comparisons and stuff when I was thinking about switching from mysql to postgres. So keep in mind that I'm just talking averages and typical webdev here.Īnd for more complex queries with lots of joins and stuff, postgres is known to have a better query planner, so it will likely be faster there anyway.Įven the current Debian stable release has now dumped the official/oracle mysql for the mariadb fork. But as most will tell you in any db forum - there's rarely a simple "product x is faster" when it comes to databases, it depends how you're using it. Any benefits mysql has in some simple usage situations rarely outweighs all the other feature, technical and reliability benefits of postgres. It generally only would make sense if you had some very specific performance requirements where it made a difference for you - and even then, not for all of your data.Īnd in that case maybe that high-throughput task shouldn't be being performed in SQL to begin with.įrom what I've read (a lot), these days the performance between postgres and mysql+innodb is pretty much the same on average. I would never use MyISAM as a primary datastore these days. Using InnoDB (supports ACID), the performance differences to postgres seem to fade away. If you're reading comparisons that were written or reporting on stuff built 5+ years ago, then quite a lot of them are talking about MyISAM (no acid) on mysql, and usually with very simple schemas and queries. Most of what you read on the web is old, and then you see a lot of forum posts repeating that info later on too. ![]() In my small research i have found that MySQL is faster than Postgres because Postgres supports ACID. ![]() Very unlikely I'll ever start any new projects with mysql from now on. I used mysql exclusively for about 16 years and only starting using postgres last year on my new projects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |