Table Partitioning

Partition by Range (e.g. by month)

Partition Pruning

  • EXPLAIN shows “Partitions: filtered” for date-range queries

PgBouncer

  • transaction mode
  • Spring compatibility