undefined | Better HN

0 pointsTylerE11mo ago0 comments

The concern isn’t the sign of the db on disc but doubling the size of all the indexes in memory

0 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.

j / k navigate · click thread line to collapse

0 pointsTylerE11mo ago0 comments

The concern isn’t the sign of the db on disc but doubling the size of all the indexes in memory

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.

j / k navigate · click thread line to collapse