pg_cron is an open-source PostgreSQL extension that allows users to schedule and run SQL commands on a periodic basis. Originally a side project for the author, it has now become a standard tool for many PostgreSQL users. The latest version of pg_cron, 1.5, introduced the ability to schedule jobs every few seconds, which has been a highly requested feature. This allows for real-time insights, anomaly detection, and syncing from external sources, among other use cases. The author recommends being cautious when using this feature, as the log can quickly become large when running jobs at such a high frequency. Additionally, the author discusses the scalability of pg_cron and how it can be used as a foundational scheduling tool for more complex workflows.
https://www.citusdata.com/blog/2023/10/26/making-postgres-tick-new-features-in-pg-cron/