Q7 PostgreSQL Domain 2 · 25–30% of exam

A team uses pg_cron to schedule a nightly job that refreshes materialized views and re-embeds changed documents. Which extension provides cron scheduling in PostgreSQL?

  1. A pg_agent
  2. B pgcron
  3. C pg_cron (correct answer)
  4. D pg_scheduler

Shortcut: pg_cron is a cron-based job scheduler for PostgreSQL that runs scheduled SQL commands inside the database. It is supported on Azure Database for PostgreSQL Flexible Server.