diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2022-04-04 15:52:02 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2022-04-04 15:52:02 -0700 |
| commit | dadb26935c4d255c5a662f1e758bcf53864f7f95 (patch) | |
| tree | f29f7c689a2f7d288cc2d07cec040b8edf8c1380 /sql/migrations/2019-12-19-060141_init/up.sql | |
| parent | c4caeaedc63c2bb2f9bb9f6be6826480aefc9caf (diff) | |
| download | sandcrawler-dadb26935c4d255c5a662f1e758bcf53864f7f95.tar.gz sandcrawler-dadb26935c4d255c5a662f1e758bcf53864f7f95.zip | |
sql: add source/created index on ingest_request table
Diffstat (limited to 'sql/migrations/2019-12-19-060141_init/up.sql')
| -rw-r--r-- | sql/migrations/2019-12-19-060141_init/up.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index 23a935e..33dba66 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -149,6 +149,7 @@ CREATE TABLE IF NOT EXISTS ingest_request ( PRIMARY KEY (link_source, link_source_id, ingest_type, base_url) ); CREATE INDEX ingest_request_base_url_idx ON ingest_request(base_url, ingest_type); +CREATE INDEX ingest_request_source_created_idx ON ingest_request(ingest_request_source, created); CREATE TABLE IF NOT EXISTS ingest_file_result ( ingest_type TEXT NOT NULL CHECK (octet_length(ingest_type) >= 1), |