Remove c
article thumbnail

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

Percona

Cron scheduler 00 01,12 * * * psql -c “SELECT pg_partman.run_maintenance()” Advantages of pg_partman Using pg_partman, you can define data retention to automatically move data into archived partitions or drop the partition.

Storage 98