diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-01-09 19:35:16 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-01-09 19:35:16 +0100 |
| commit | 0cf46d8e5995f84a642795ddf214776ed8d4077f (patch) | |
| tree | 525fd968b29defed6e08ea6cbfedb677cfe7c48e /src/exchangedb/0002-work_shards.sql | |
| parent | d782dd7f54a1b86c402a99428364e86f38552f76 (diff) | |
| download | exchange-0cf46d8e5995f84a642795ddf214776ed8d4077f.tar.gz exchange-0cf46d8e5995f84a642795ddf214776ed8d4077f.tar.bz2 exchange-0cf46d8e5995f84a642795ddf214776ed8d4077f.zip | |
-add index on shard
Diffstat (limited to 'src/exchangedb/0002-work_shards.sql')
| -rw-r--r-- | src/exchangedb/0002-work_shards.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/exchangedb/0002-work_shards.sql b/src/exchangedb/0002-work_shards.sql index 016207d37..220745d43 100644 --- 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); |