4 ms·
Not sure if this makes sense, however, I've always preferred MariaDB to Postgres because it feels lighter. And I haven't really come up against any significant
by osrec 7y ago
Not sure if this makes sense, however, I've always preferred MariaDB to Postgres because it feels lighter. And I haven't really come up against any significant limitations in MariaDB that would make me want to switch to Postgres.
- philliphaydon 7y agoDoes MariaDB have documentation?
- osrec 7y agohttps://mariadb.com/kb/en/documentation/ https://mariadb.com/kb/en/documentation/
- philliphaydon 7y agoAhh under server documentation. The site could use some TLC. Not easy to navigate. Thanks.
- edoceo 7y agoHeavy writes, mulitstep transactions is where PG has always won for me vs Maria and MySQL - it was even more pronounced when I decided I'm all in on PG c2003
- redis_mlc 7y ago1) 2003 was 17 years ago. 2) PG has a write amplification problem with multiple indexes that MySQL Innodb doesn't have.
- asah 7y agoI'm curious how innodb solves this, given that the theory of indices pretty much demands write amplification by definition. Postgres' WA is worse?
- edoceo 7y agoIts from an Uber post - more story and follow up in this post https://dba.stackexchange.com/questions/226879/did-postgresql-write-amplification-reduction-warm-efforts-get-released-in-10-1 https://dba.stackexchange.com/questions/226879/did-postgresq...
- djd20 7y agoYeah - they indexed every single column.... also - what may not have worked for uber, will be just fine for 99% of usecases. How often do you work with that kind of load. What they moved to isn't so much mysql, rather mysql used as a key value store with 0 relational database usage. Not really a postgres issue, rather one of being too big for relational databases.
- edoceo 7y ago2003 was when I picked PG as preferred. Since then I've continues to work with DBs and of course evaluated Maria at least every 18 months (or a client was paying me to do this). PG continues to win for nearly every case I throw at it. Like when NoSQL was a fad (why tho!?) but PG had native json, then jsonb types. I didn't even have to look at that silly Mongo, PG baba!
- djd20 7y agoYou have a problem if you're trying to index every column...
- stickfigure 7y agoTransactional DDL. I for the life of me cannot understand how anyone survives in production without this. Half-applied migrations will prevent you from both deploying new code and rolling back to the old. Expect significant downtime.