13 lines
431 B
SQL
13 lines
431 B
SQL
-- v2_job_queue: drop obsolete indexes and create new ones
|
|
DROP INDEX IF EXISTS concurrency_limit_stats_queue;
|
|
DROP INDEX IF EXISTS queue_sort;
|
|
DROP INDEX IF EXISTS queue_sort_2;
|
|
|
|
CREATE INDEX IF NOT EXISTS queue_sort_v2
|
|
ON v2_job_queue (priority DESC NULLS LAST, scheduled_for, tag)
|
|
WHERE running = false;
|
|
|
|
CREATE INDEX IF NOT EXISTS v2_job_queue_suspend
|
|
ON v2_job_queue (workspace_id, suspend)
|
|
WHERE suspend > 0;
|