Numbers To Know medium
You are storing 1 Billion rows. Using a UUID (16 bytes) as the Primary Key instead of a BigInt (8 bytes) adds how much *extra* raw data size (excluding index overhead)?
- A 8 GB
- B 16 GB
- C 1 GB
- D 100 MB
Answer: A. 8 GB
Difference is 8 bytes per row. $1 Billion \times 8 \text{ bytes} = 8 GB$. Index overhead typically doubles this cost.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- What is the maximum allowed downtime per year for a system targeting '99.9%' (Three Nines) availability?
- What is the typical size of a standard ASCII character (e.g., 'A')?
- What is the typical Round Trip Time (RTT) for a single network packet traveling between New York and London (Transatlantic)?
- Network bandwidth is usually denoted in **bits** per second (Gbps), while storage is in **Bytes** (GB). What is the conversion ratio?
- Storing a password using a secure algorithm like bcrypt (cost 10) or Argon2 typically consumes how much storage per user?
- How much power does a typical fully-loaded rack-mount server consume?