Partitions are an excellent mechanism to reduce your queryable data size. PG_partman is a tool that enables DB admins to create partitions in the Postgres database. It is packed with features and offers a lot of functionality to create and manage partitioned tables.

Ideally, when partitions are created using pg_partman, we need a monitoring mechanism to ensure that we have enough to accommodate our incoming data as time passes. This post explains how to monitor and auto-create partitions in pg_partman on an AWS infrastructure.

Leave a Reply

Your email address will not be published. Required fields are marked *