#pg #postgres Table partitioning using #Partman #ytshort #trending 🔥🔥

WHAT IS PG_PARTMAN?
 It is a PostgreSQL extension to create and manage both time-based and
serial-based table partition sets.
 It is a PostgreSQL extension that helps you to manage both time series and
serial-based table partition sets, including automatic management of
partition creation and runtime maintenance.
 It works with the native partitioning introduced into PostgreSQL 10 so
users can benefit from significant performance enhancements. https://www.youtube.com/@MCCAknowledgeSharingCentre  Sub-partitioning is also supported.
 Child table & trigger function creation is all managed by the extension itself.
 Tables with existing data can also have their data partitioned in easily managed
smaller batches.
 Optional retention policy can automatically drop partitions no longer needed.
 A background worker (BGW) process is included to automatically run partition
maintenance without the need of an external scheduler (cron, etc) in most cases.