[Solved] Which of these is a valid reason to use sub-partitioning in PostgreSQL? — Ans: To improve query performance by narrowing data scans | PostgreSQL

PostgreSQL - Table Partitioning

Which of these is a valid reason to use sub-partitioning in PostgreSQL?

ATo reduce disk space by compressing data

BTo improve query performance by narrowing data scans

CTo automatically backup partitions

DTo encrypt data in partitions

Step-by-Step Solution

Solution:

Step 1: Identify sub-partitioning benefits
Sub-partitioning helps organize data for faster access.
Step 2: Match benefit to options
Improving query speed by scanning less data fits sub-partitioning.
Final Answer:
To improve query performance by narrowing data scans -> Option B
Quick Check:
Sub-partitioning improves query speed [OK]

Quick Trick: Sub-partitioning narrows data scans for speed [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of these is a valid reason to use sub-partitioning in PostgreSQL?