[Solved] Given a partitioned table logs with partitions logs_2023 and logs_2024, what will be the result of this command?ALTER TABLE logs DETACH PARTITION logs_2023;Then querying SELECT count(*) FROM logs; | PostgreSQL

PostgreSQL - Table Partitioning

Given a partitioned table logs with partitions logs_2023 and logs_2024, what will be the result of this command?

ALTER TABLE logs DETACH PARTITION logs_2023;

Then querying SELECT count(*) FROM logs;

ACount of rows only from logs_2024 partition

BCount of rows from both logs_2023 and logs_2024 partitions

CError because logs_2023 is detached

DCount of rows only from logs_2023 partition

Step-by-Step Solution

Solution:

Step 1: Understand DETACH PARTITION effect
Detaching removes the partition from the partitioned table but keeps the data in the detached table.
Step 2: Query behavior after detach
Querying the partitioned table counts rows only in attached partitions, so logs_2023 rows are excluded.
Final Answer:
Count of rows only from logs_2024 partition -> Option A
Quick Check:
Detached partition excluded from queries = Count of rows only from logs_2024 partition [OK]

Quick Trick: Detached partitions are excluded from partitioned table queries [OK]

Common Mistakes:

Assuming detached partitions still count in queries
Expecting an error after detach
Confusing detach with drop

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given a partitioned table logs with partitions logs_2023 and logs_2024, what will be the result of this command?

Step 1: Understand DETACH PARTITION effect

Step 2: Query behavior after detach

Final Answer:

Quick Check:

Want More Practice?