PGTQ: the PostgreSQL-backed python task queue

work in progress, not tested or usable (yet?)

Build Status Coverage Status

PGTQ is a task queue (also known as job queue) system. It can be used you want to decouple execution of background tasks from the current thread. For example, if you have a flask based web-app, you might want to send an email due to some user action, but waiting for the SMTP server to report success may block the page render for too long. Instead, you can push an item into the task queue, and then immediately reply to the HTTP request. In the background, a worker process will pick up the task of sending the email.

PGTQ tasks are writting in python, with PostgreSQL as the backing store.


Needs PostreSQL 9.5 or later installed.

Create a database:

createdb q

Create a task queue:

import pgtq

q = pgtq.PgTq('test_queue', "dbname=q user=postgres") 

A "scheduler" process is responsible for pushing scheduled (as opposed to immediate) tasks onto the task queue at the correct time. Failed tasks that are to be retried later become scheduled tasks, so, even if you are not using scheduled tasks, you should have the shceduler running. Provide it with the queue name and connection string like this:

scheduler test_queue postgresql://[email protected]:63630/test_queue

There is usually no reason to run more than one scheduler process, but doing so will not cause duplicate tasks or similar problems.

A Handler is a function that can perform the work of completing a given task. You can create one with the handler decorator provided by the queue:

def add_numbers(a, b):
    return a + b

add_numbers is now a Handler, but it still can be called directly. This will run immediately, blocking the current thread, and without going through the task queue:

add_numbers(2, 3)

Alternatively, you can push a task into the queue:

add_numbers.push(2, 3)

This will return immediately without computing the result. As soon as possible, a worker process should remove the task from the queue and process it. The arguments must be anything JSON serialisable.

A Task can be fetched out of the queue (e.g. in a worker process) using pop:


Usually, however, you will want to run dedicated worker processes. You have to set these up yourself, because the handlers need to be imported in the process or the worker is useless. You should use the worker main loop functions to correctly extract items out of the queue, handling automatic retries etc.:

import worker

if __name__ == "__main__":

main_loop never returns. You can daemonise this process prior to starting the main loop, or run it in a process manager or terminal multiplexer any other setup you like to ensure it keeps running in the background.

The name of the Task as stored in the database is accessable via By default the name of the handler function is used, but you can overide it in the handler decorator:

def add_numbers(a, b):
    return a + b

This may be useful to avoid name conflicts.


Isn't it bad to use an RDBMS for a queue?

Maybe. Since this is a work in progress I'm not sure how well it's going to work out yet. Since tasks have to go through RDBMS paging system, B-Trees and so on, its never going to match the raw latency of something as simple as a ring buffer. It may also not scale out as well as a dedicated message queue system like 0MQ or rabbitmq. But I hope it has some advantages that might make it useful in the right circumstances:

  • If you are already using postgres, you can now run a task queue with zero extra infrastructure. I have previously used celery, and experienced a lot of operational instability with both rabbit and redis backing stores. Meanwhile, pg is almost always solid.
  • It becomes trivial to fish out the current queue state and history. Instead of rellying on obscure message queue commands you can query the database yourself. That way you can build an admin panel easily, and include any kind of analysis of task frequency, queue length (over time), etc.
  • The list of runnable tasks can be included in your existing backup system
  • It might be possible to tie task queue operations and business logic transactions into a single transaction. For example, it should be possible to only create a "send signup email" task if and only if the user account was 100% certainly created. Contrast to how difficult it is to come up with a commit protocol that can keep an RDBMS and seperate message queue in sync in the presence of byzantine failures.


PostgreSQL-backed python task queue

Pgtq Info

⭐ Stars 12
🔗 Source Code
🕒 Last Update a year ago
🕒 Created 5 years ago
🐞 Open Issues 32
➗ Star-Issue Ratio 0
😎 Author DanielCollins