Mercurial > gemma

annotate schema/updates/1434/01.add_import_state_idx.sql @ 5122:0b6b62d247e8 queued-stage-done

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prioritize review jobs on selection This reverts rev. 37784b70eea3 and instead moves review jobs forward in the queue when fetching the next job to be run. Also optimized index setup for filtering by state but not enqueued.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Mar 2020 14:41:23 +0100
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5122
0b6b62d247e8 Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 DROP INDEX import.enqueued_idx;
0b6b62d247e8 Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 CREATE INDEX enqueued_idx ON import.imports(enqueued);
0b6b62d247e8 Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 CREATE INDEX state_idx ON import.imports(state);