PostgreSQLhard

Table partitioning in Postgres — when does it help (and a common pitfall)?

Answer

Partitioning helps large tables where queries filter by a partition key (time, tenant) so the planner can prune partitions. A common pitfall is not filtering by the partition key — then you scan many partitions and get little benefit.

Related questions

PostgreSQL

Materialized view vs view: what’s the difference?

#postgres#views#materialized-view

PostgreSQL

PostgreSQL bloat: what causes it and how do you reduce it?

#postgres#mvcc#vacuum

PostgreSQL

PostgreSQL `COPY`: what is it used for and why is it fast?

#postgres#copy#bulk-load

PostgreSQL

What is a partial index in PostgreSQL and when is it useful?

#postgres#index#partial-index

PostgreSQL

What is `work_mem` and why can sorts or hash joins spill to disk?

#work_mem#sort#hash-join

PostgreSQL

BRIN vs B-tree index — when is BRIN a good fit?

#brin#btree#index