Hacker GitHub

← All repos

citusdata/pg_cron

View on GitHub ↗ ★ 3,914 C

Run periodic jobs in PostgreSQL

9 mentions on Hacker News by 9 people: 4 stories, 5 comments · first 2016-09-05 · latest 2025-05-30

Mentions per year 9 mentions · busiest year 2020 (3)
20082026
AllStoriesComments NewestTopOldest
  1. …* https://github.com/oban-bg/oban * https://github.com/pgadmin-org/pgagent * https://github.com/citusdata/pg_cron etc. There are plenty of options to choose from. 0: https://github.com/timgit/pg-boss
    comment by zie · 2025-05-30 · in How to run cron jobs in Postgres without extra infrastructure
  2. Maybe something like https://github.com/citusdata/pg_cron or if it's not a rolling time window, just trigger functions that get called whenever some expression in SQL is true.
    comment by chartpath · 2021-10-21 · in Issues we've encountered while building a Kafka based data processing pipeline
  3. …), data sharding ( https://www.citusdata.com/ ), or even database cron scheduling ( https://github.com/citusdata/pg_cron ) are also good examples of things that are well suited to be extensions. To be honest, I have a hard time imagining…
    comment by gshulegaard · 2020-07-13 · in PGX: Write Postgres extensions in Rust instead of C
  4. I have not really dug into this, but we use pg_cron [0] quite extensively and works quite well. [0] https://github.com/citusdata/pg_cron
    comment by doh · 2020-01-30 · in Pg_timetable: PostgreSQL Job Scheduling
  5. …to run things periodically. If you'd want to stay solely within Postgres, there is also pg_cron ( https://github.com/citusdata/pg_cron ) which could be used to call REFRESH MATERIALIZED VIEW from within the database.
    comment by lfittl · 2020-01-16 · in Effectively Using Materialized Views in Ruby on Rails