select /*+LEADING(r upt upkc utc)*/ r.recname, upt.table_name, utp.partition_name, utp.high_value, upt.interval interval_size ...

Partition management extension for PostgreSQL. Contribute to pgpartman/pg_partman development by creating an account on GitHub.

I will also describe how to handle partitions efficiently for both query and ingest workloads, and how to manage cold (old) partitions where the read requirements are quite different from the hot ...