# Next month partitions

DevFeed: [Next month partitions](<https://devfeed.tech/articles/next-month-partitions-34431.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/07/next-month-partitions/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-07-27T20:35:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Script](<https://devfeed.tech/topics/script.md>)

Tags: [partitions](<https://devfeed.tech/tags/partitions.md>), [query](<https://devfeed.tech/tags/query.md>), [scripts](<https://devfeed.tech/tags/scripts.md>)

## AI overview

A short guide to checking whether the next monthly table partitions have been created, using a catalog query. It also mentions Nagios scripts for alerting when partition creation is forgotten and explains how partition naming supports query matching.

## Source excerpt

When you do partition your tables monthly, then comes the question of when to create next partitions. I tend to create them just the week before next month and I have some nice nagios scripts to alert me in case I've forgotten to do so. How to check that by hand in the end of a month?