3 ms·
Out of curiosity, why do you need to use both Postgres and MySQL/MariaDB?
by olalonde 14y ago
Out of curiosity, why do you need to use both Postgres and MySQL/MariaDB?
- eksith 14y agoOur clients usually have a lot already running on InnoDB so we always have similar setups (preferably identical except the same volume of data) to what they have on the side. Can't tell you how many problems we've caught that way and how much it simplifies things during deployment. If starting anew, it's Postgres. Our internal stuff is almost all running straight Postgres but a small part of our application stack is abstracted on top of it to provide document DB functionality.
- harichinnan 14y agoMysql cannot do parallel query. That's a single query won't spin off multiple threads and work in parallel. This makes it a bad solution for say aggregating over large data. Mysql can handle lots of threads(queries) in parallel making it an ideal solution for web. Postgres can do parallel query.
- HarrisonFisk 14y agoPostgreSQL doesn't do parallel query.
- EwanToo 14y agoMySQL can do parallel querying through some of the less common back-ends, like Infinidb, which are more suited to warehousing than OLTP like InnoDB/XtraDB. http://infinidb.org/component/content/article/53/158 http://infinidb.org/component/content/article/53/158