Q35 PostgreSQL Domain 2 · 25–30% of exam

Which PostgreSQL extension is used to partition a large table by range (e.g., by date) for improved query performance?

  1. A pg_partman
  2. B Declarative partitioning (native PostgreSQL 10+) (correct answer)
  3. C pg_cron
  4. D TimescaleDB

Shortcut: PostgreSQL's native declarative partitioning (PARTITION BY RANGE/LIST/HASH) efficiently partitions large tables. pg_partman automates partition management (creating/dropping partitions).