The concern isn’t the sign of the db on disc but doubling the size of all the in... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		TylerE 8 months ago \| parent \| context \| favorite \| on: My takeaways from DjangoCon EU 2025 The concern isn’t the sign of the db on disc but doubling the size of all the indexes in memory

sgarland 8 months ago [–]

Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.

pyuser583 8 months ago | [–]

Wow did not know that. MySQL has tons of hidden behavior.

sgarland 8 months ago | | [–]

So does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact