Migrate scheduled jobs to pg_timetable from pgAgent
Why migrate to pg_timetable from pgAgent? There are many reasons, actually, why people might want to export pgAgent jobs to pg_timetable. Most of them may be spotted by taking a look at the PostgreSQL schedulers comparison table I introduced in one of my previous posts and the supported platform table from the official readme. In […]
Migrate scheduled jobs to pg_timetable from pg_cron
Why migrate to pg_timetable from pg_cron? There are a lot of reasons you may want to migrate from pg_cron: maybe you need to run a scheduler on a platform pg_cron doesn’t support; or you want to run several parallel schedulers simultaneously; it’s possible you hit the bugs in pg_cron that haven’t been fixed for ages […]
Run multiple jobs but limit number of sessions – PostgreSQL: pg_timetable
If you are using pg_timetable to run multiple jobs on PostgreSQL, you need to understand how to calculate the number of database sessions, so you don’t overload your system. Recently, a related question came up on pg_timetable’s Github Disscussion page: What do you do when you get the following error message: “Failed to send chain to […]
pg_timetable v4.4 is available immediately!
Our team is proud to introduce a new pg_timetable v4.4 release! This time we focused on implementing a couple of new features, as well as improving performance. I want to remind you that pg_timetable is a community project. So, please, don’t hesitate to ask any questions, to report bugs, to star the pg_timetable project, and […]
PostgreSQL schedulers: comparison table
Hello, my name is Pavlo Golub, and I am a scheduler addict. That began when I implemented pg_timetable for PostgreSQL. I wrote a lot about it. In this post, I want to share the result of my investigations on the schedulers available for PostgreSQL. I gave a talk about this topic at the CERN meetup, so […]
pg_timetable v4 is out and available immediately!
Our team is proud to introduce a new major pg_timetable v4 release! This time a huge amount of work has been done and the pg_timetable v4 release is backward-incompatible with previous versions. However, job migration is straightforward and shouldn’t stop anyone from updating. We’ve added detailed Read the Docs documentation and will enhance it further. […]
pg_timetable: asynchronous chain execution
Intro I wrote about the new pg_timetable 3 major release not so long ago. Three essential features were highlighted: new session locking implementation; new jackc/pgx Golang library used; exclusive chain execution. Meanwhile, two minor releases have come out, and the current version is v3.2. It focuses on the completely new and fantastic feature asynchronous control […]
PostgreSQL exclusive cron jobs using pg_timetable scheduler
I wrote about the new pg_timetable 3 major release not so long ago. Two essential features were highlighted: – new session locking implementation – new jackc/pgx Golang library used Today I want to reveal one more advanced feature! Fasten your seat belts! First, we need to distinguish exclusive client session mode from exclusive chain execution […]
pg_timetable v3 is out!
As you probably know, pg_timetable is the advanced PostgreSQL cron compatible scheduler already released! Usually, any major release introduces absolutely new functionality as well as some backward incompatibilities. However, the only backward incompatibility present in this release is that the base task SHELL changed its name to PROGRAM. Yes, that’s all. 🙂 Now, let’s check […]
pg_timetable: start-up improvements
¡Hola, queridos amigos! We’ve released several valuable features for pg_timetable in May. It’s summer already, and time is flying fast! I hope all of you are well and safe, as well as your families and friends. Here I want to introduce what’s new and how that is useful briefly. If you are unfamiliar with pg_timetable, […]
pg_timetable: Advanced PostgreSQL cron-like scheduler released!
pg_timetable: Advanced PostgreSQL cron-like scheduler released! Hello there, this is your developer speaking… I’m struggling with how to start this post, since I’ve procrastinated a lot. There should be at least 5 published posts on this topic already. But there is only one by Hans-Jürgen Schönig. I’m thanking him for trying to cover my back, […]