Posted inDatabase
pg_cron: Schedule PostgreSQL Tasks Inside the Database Without OS Cron
pg_cron is a PostgreSQL extension that schedules SQL jobs — VACUUM, data archiving, threshold notifications — directly inside the database as a background worker. No external cron, no credential sprawl, no silent failures. This guide covers installation, three real-world use cases, and the practices that keep pg_cron solid in production.
