After having created the partitions, now we will create a maintenance function that will help us running queries on every partition.   We saw in the first part how to dynamically create the needed partitions. Just add this function in … Continue reading →

We will share a simple approach to migrate existing tables to partitioned versions of them with Postgresql. The partitions will be created on demand with just a few lines of codes. It is useful during off-line migration, and can be … Continue reading →