logoalt Hacker News

HackerThemAllyesterday at 10:28 PM3 repliesview on HN

I prefer PostgreSQL. Don't see any advantage of MySQL/Maria.


Replies

evaneliasyesterday at 11:40 PM

A few major areas where MySQL/MariaDB excels:

Threaded connection model (no process spawning)

Undo-based MVCC (no need for vacuum)

InnoDB's use of a clustered index for PK (has pros/cons, but better for some workloads)

Ability to use alternative storage engines such as MyRocks (LSM based instead of B-tree; best-in-class compression)

Support for index hints (so query plans won't randomly change and bring your site down)

More mature logical replication (fully supports DDL, has no concept of limited "replication slots", etc)

That all said, there are also many areas where Postgres is better! Like all things in computer science, there are architectural trade-offs, and no single silver bullet is the best choice for all workloads.

show 1 reply
dwedgeyesterday at 11:38 PM

What do you see as advantages of postgres over mysql? I see these comments at work quite often and there isn't always much substance behind them

direwolf20yesterday at 11:30 PM

Different concurrency model