New Postgres extensions: pg_cron and pg_partman_bgw
We've added two new Postgres extensions.
pg_cron
Schedule SQL commands to run at specific times using familiar cron syntax, directly within your PostgreSQL database.
pg_partman_bgw
Automate table partition maintenance with this background worker extension that works alongside pg_partman
. It automatically handles partition creation, deletion, and maintenance without manual intervention.
Both extensions are now available for all PlanetScale Postgres databases and can be enabled through the Extensions tab in your cluster configuration.