From fe148d0187d273b80ac4ff7e45400fb442b6d3a6 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sun, 12 Mar 2017 15:02:18 +0100 Subject: create an index on priority, id --- joblib.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/joblib.py b/joblib.py index 1b77b2e..8faf71f 100644 --- a/joblib.py +++ b/joblib.py @@ -40,6 +40,9 @@ class JobQueue(object): payload JSONB ) """) + await con.execute(""" + CREATE UNIQUE INDEX ON jobs(priority, id) + """) async def request(self, jobtype, payload, priority=0): """Create a new job and return its id.""" -- cgit v1.3.1