pg_cron icon indicating copy to clipboard operation
pg_cron copied to clipboard

Achieve second granularity

Open TsinghuaLucky912 opened this issue 3 years ago • 6 comments

Hello,all

I want to be in PG_ Cron implements the function that the minimum unit is the second granularity!

I wonder if this problem can be realized? And are there any difficulties?

thinks!

TsinghuaLucky912 avatar Sep 06 '21 09:09 TsinghuaLucky912

Might be related to this issue: https://github.com/citusdata/pg_cron/issues/6

ekeric13 avatar Sep 08 '21 05:09 ekeric13

You misunderstood what I meant. I mean: I want to modify the source code of pg_cron to support second-level accuracy.

Might be related to this issue: #6

TsinghuaLucky912 avatar Sep 08 '21 05:09 TsinghuaLucky912

Might be related to this issue: #6

In fact, I have written a version of the code, which is added to the source code of pg_cron. I am now testing

TsinghuaLucky912 avatar Sep 08 '21 05:09 TsinghuaLucky912

Hello, everyone.

I just submitted my code. Interested friends can check and communicate.

mycode here

TsinghuaLucky912 avatar Sep 08 '21 06:09 TsinghuaLucky912

our forks will be release in end of Q1, we have support for second granularity and TZ.

hslightdb avatar Feb 08 '22 07:02 hslightdb

our forks will be release in end of Q1, we have support for second granularity and TZ.

I am very happy to see that the developers of pg_cron support the second level function, I believe this is very important for those who are interested in pg_cron

My previous submission is temporarily closed, if you are interested, you can read this link:

https://github.com/citusdata/pg_cron/pull/149/files

Thank you all, come to China with blessings!

TsinghuaLucky912 avatar Feb 08 '22 08:02 TsinghuaLucky912