commit 0cf46d8e5995f84a642795ddf214776ed8d4077f parent d782dd7f54a1b86c402a99428364e86f38552f76 Author: Christian Grothoff <christian@grothoff.org> Date: Mon, 9 Jan 2023 19:35:16 +0100 -add index on shard Diffstat:
| M | src/exchangedb/0002-work_shards.sql | | | 5 | +++++ |
1 file changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/exchangedb/0002-work_shards.sql b/src/exchangedb/0002-work_shards.sql @@ -49,3 +49,8 @@ CREATE INDEX work_shards_by_end_row_index ON work_shards (end_row DESC); +CREATE INDEX work_shards_by_rows + ON work_shards + (job_name + ,start_row + ,end_row);