Given a table partitioned by range on a date column, what happens when a query filters on a date outside all partitions?

medium📝 query result Q4 of 15

PostgreSQL - Table Partitioning

AThe query returns rows from the closest partition

BThe query returns no rows and scans no partitions

CThe query causes an error due to missing partition

DThe query scans all partitions and returns all rows

Step-by-Step Solution

Solution:

Step 1: Understand range partitioning behavior
Range partitions cover specific date ranges; queries outside these ranges find no data.
Step 2: Recognize query pruning
PostgreSQL skips partitions that cannot contain matching rows, so no partitions are scanned.
Final Answer:
The query returns no rows and scans no partitions -> Option B
Quick Check:
Partition pruning excludes irrelevant partitions [OK]

Quick Trick: Queries outside partitions scan nothing and return empty results [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free