[Solved] What is the main purpose of sub-partitioning in PostgreSQL? — Ans: To split data twice for better organization and faster queries | PostgreSQL

PostgreSQL - Table Partitioning

What is the main purpose of sub-partitioning in PostgreSQL?

ATo encrypt data within partitions

BTo create backups of partitions automatically

CTo merge multiple partitions into one

DTo split data twice for better organization and faster queries

Step-by-Step Solution

Solution:

Step 1: Understand partitioning basics
Partitioning divides a table into parts to improve management and performance.
Step 2: Recognize sub-partitioning role
Sub-partitioning splits each partition further, organizing data more finely and speeding up queries.
Final Answer:
To split data twice for better organization and faster queries -> Option D
Quick Check:
Sub-partitioning = double data split [OK]

Quick Trick: Sub-partitioning means splitting partitions again [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of sub-partitioning in PostgreSQL?