Comment on My takeaways from DjangoCon EU 2025parentComments−sgarland1yOr if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.−pyuser5831yWow did not know that. MySQL has tons of hidden behavior.−sgarland1ySo does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.
Comments
Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.
Wow did not know that. MySQL has tons of hidden behavior.
So does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.