3 ms·

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

• sgarland 1y ago
  Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.
  • pyuser583 1y ago
    Wow did not know that. MySQL has tons of hidden behavior.
    • sgarland 1y ago
      So does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.