PostgreSQL - Table Partitioning
If a hash partitioned table has 3 partitions with modulus 3, what happens when you insert a row with a key value of 10?
If a hash partitioned table has 3 partitions with modulus 3, what happens when you insert a row with a key value of 10?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Calculate remainder of 10 modulo 3
10 % 3 = 1.Step 2: Assign to partition with remainder 1
Row goes to partition where remainder equals 1.Final Answer:
It goes to partition with remainder 1 -> Option BQuick Check:
Hash partitioning uses remainder to assign partitions [OK]
Quick Trick: Use key % modulus to find partition remainder [OK]
Common Mistakes:
- Thinking key must be divisible by modulus
- Assuming duplicates in all partitions
Master "Table Partitioning" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes