pg_cron 1.5 support to allow second-interval CRON jobs

Question

Hello,

We are currently operating a near real-time application using PostgreSQL in Microsoft Azure, and we need to execute several CRON jobs to refresh and transform our data stream. To accomplish this, we are aiming to implement a 3-second interval for some of these procedures. However, we've encountered a limitation with pg_cron 1.4, which is the highest supported version for Azure Database for PostgreSQL at the moment.

According to the release notes at https://github.com/citusdata/pg_cron/releases/tag/v1.5.0, pg_cron version 1.5.0 and above introduces a new feature:

• Adds the possibility of scheduling a job with a 1-59 second interval

We would like to inquire about the availability of support for pg_cron version 1.5 or higher in Azure Database for PostgreSQL. If it is not currently supported, could you kindly suggest the best alternative approaches to achieve this level of scheduling granularity?

Thanks
CL

Answer 1

@Chia Thank you for reaching out.

The highest supported version is currently pg_cron 1.4, which does not support scheduling jobs with a 1-59 second interval.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#postgres-13-extensions

We recommend you raise feedback over Azure Feedback Channel for Azure Database for PostgreSQL so that concerned team could consider this feature depending on the importance and up-votes received.

Regards,

Oury