Content
@
1 reply
0 recast
2 reactions
✳️ dcposch on daimo
@dcposch.eth
Postgres is surprisingly bad. I think we’ve been stockholm’d into treating it as the default option. I’ll write more detail if curious, but the query planner is garbage & that’s just one issue. Has anyone successfully switched to MariaDB or other options?
9 replies
35 recasts
235 reactions
Samuel ツ
@samuellhuber.eth
would love to read the expanded detail cc @rjs @downshift.eth @rafi @ryansmith @leewardbound
1 reply
0 recast
7 reactions
Leeward Bound
@leewardbound
lol maria/mysql is awful, that's what we were stockholmed into for a decade or two before psql became more popular not sure what OP is talking about, psql as industry defacto is a huge improvement over the prior state of things
3 replies
0 recast
6 reactions
✳️ dcposch on daimo
@dcposch.eth
There are a few large projects that switched the other way, notably Uber a few years ago
3 replies
0 recast
1 reaction
Ryan
@ryansmith
Uber isn’t a wholesale success story. There are a lot of caveats that you can search for. The big win for them was reduced write amplification (and binary replication) due to how PG does indexes. Unless you are doing 100k writes / second I doubt this will matter.
0 reply
0 recast
2 reactions
Moon
@moon.eth
They wrote about it, it wasn't because postgres sucked, it was because of tradeoffs particular to their business and design.
0 reply
0 recast
1 reaction
Leeward Bound
@leewardbound
if i walked into a shop and found Maria, id walk right back out. what are your specific complaints? i assure you that anything maria may win on is a recent improvement. ive ran tb-scale clusters of both dbs and this is generally considered solved science
0 reply
0 recast
1 reaction
