| From: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to run a task continuously in the background |
| Date: | 2019-07-12 05:00:24 |
| Message-ID: | 524EDA3D-6A0F-4E67-AA7E-0E743A8B79E1@mikatiming.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
pg_cron, perhaps?
https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/
I _think_ it ticks all three of your boxes.
I also checked pg_cron, but this has the disadvantage that it allows starting a job at most once a minute. On the other hand, the job runs as long as there are records to process. And during this time nothing should be queued again.
DIrk
--
Dirk Mika
Software Developer
[cid:image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png]
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk(dot)mika(at)mikatiming(dot)de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
[cid:CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg]<https://youtu.be/qfOFXrpSKLQ>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Mika | 2019-07-12 05:06:14 | Re: How to run a task continuously in the background |
| Previous Message | Michael Paquier | 2019-07-12 04:45:47 | Re: Download link for postgres 10.8 edb software |