Why should you care?

Flipkart-scale PostgresVerse refreshes search materialized view nightly and archives old partitions without manual DBA clicks.

See it live — copy this example

Run in pgAdmin or psql.

-- pg_cron example (extension installed)
SELECT cron.schedule(
  'refresh_product_search',
  '0 2 * * *',
  $$REFRESH MATERIALIZED VIEW CONCURRENTLY product_search_mv;$$
);

What happened?

• cron.schedule registers job name, cron expression (2 AM daily), and SQL text.
• Extension runs inside database — alternative is Windows Task Scheduler calling psql -f script.sql.

Practice next

1. CREATE EXTENSION pg_cron if available on your build.
2. Create simple materialized view product_search_mv.
3. Schedule REFRESH CONCURRENTLY job.
4. Schedule weekly VACUUM ANALYZE on hot table only.
5. Chain procedure CALL in scheduled job after COPY ingest.

Remember

pg_cron schedules SQL inside PostgreSQL. External cron plus psql works everywhere. Automate ANALYZE, partition creation, and MV refresh.

PostgresVerse search refresh

Product search MV stale during day; 2 AM refresh keeps browse fast without realtime join cost.

Outcome: Search P95 stable; ops gets cron.job_run_details alert on failure.