Hacker News new | ask | show | jobs
by sgarland 409 days ago
Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.
1 comments
pyuser583 409 days ago
Wow did not know that. MySQL has tons of hidden behavior.
link
sgarland 408 days ago
So does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.
link