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

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
line wrap: on
line source

DROP INDEX import.enqueued_idx;
CREATE INDEX enqueued_idx ON import.imports(enqueued);
CREATE INDEX state_idx ON import.imports(state);