[Solved] What is sub-partitioning in PostgreSQL? — Ans: Dividing a partition into smaller partitions based on another column | PostgreSQL

PostgreSQL - Table Partitioning

What is sub-partitioning in PostgreSQL?

AIndexing a partitioned table for faster queries

BDividing a partition into smaller partitions based on another column

CMerging multiple partitions into one

DCreating a backup of a partitioned table

Step-by-Step Solution

Solution:

Step 1: Understand partitioning basics
Partitioning splits a table into parts based on a column.
Step 2: Define sub-partitioning
Sub-partitioning means splitting each partition further by another column.
Final Answer:
Dividing a partition into smaller partitions based on another column -> Option B
Quick Check:
Sub-partitioning = Dividing partitions further [OK]

Quick Trick: Sub-partitioning splits partitions by another column [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is sub-partitioning in PostgreSQL?