Hacker News new | ask | show | jobs
by TylerE 458 days ago
The concern isn’t the sign of the db on disc but doubling the size of all the indexes in memory
1 comments
sgarland 458 days ago
Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.
link
pyuser583 458 days ago
Wow did not know that. MySQL has tons of hidden behavior.
link
sgarland 458 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