I use MySQL and SQLite often and plan on bringing more PostgreSQL into my workflow soon. With that in mind, what are the costs of using NULL in each database? I heard that MySQL adds an extra bit to each NULL column value to mark it as nullable.
This question was answered separately for PostgreSQL: How much disk-space is needed to store a NULL value using postgresql DB?
and for MySQL: NULL in MySQL (Performance & Storage)
But to recap they both use bitmask fields to mark nulls.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With