Skip to content

Database Partitioning

How to physically store the data

Horizontal Partitioning

  • Store rows of the same table in different machines
  • example
    • store European users in one machine in Europe
    • store North American users in a machine in the US

Horizontal Partitioning vs Sharding

????

Vertical Partitioning

  • store columns differently
  • frequently used columns
    • in one partition on a fast expensive machine
  • barely used columns
    • (possibly blob like profile pictures!) in a slower cheaper machine

Vertical Partitioning vs Normalization

Partitioning is how to store the data

Normalization: logical

  • remove repeated data
  • have newly created tables reference/link with each other

Last update: 2023-02-03