diff options
| author | Ethan Lee <ethanalee@google.com> | 2025-11-12 22:20:02 +0000 |
|---|---|---|
| committer | Gopher Robot <gobot@golang.org> | 2025-11-13 07:57:22 -0800 |
| commit | 24a1809772a5a1098bc61846e814b29e5fa9c24a (patch) | |
| tree | 4f36721cc36a0b277a9d642d4521f7324d8820b3 | |
| parent | 2e72efd8d3b258451de7607c85303aacbc30572b (diff) | |
| download | go-x-pkgsite-24a1809772a5a1098bc61846e814b29e5fa9c24a.tar.xz | |
migrations: add partial module_version_states (index_timestamp) index
For golang/go#76284
Change-Id: I1927b2b253d1cb67129f051c306db1b6275d3ee2
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/720080
Reviewed-by: Jonathan Amsterdam <jba@google.com>
Auto-Submit: Ethan Lee <ethanalee@google.com>
Reviewed-by: Robert Findley <rfindley@google.com>
LUCI-TryBot-Result: Go LUCI <golang-scoped@luci-project-accounts.iam.gserviceaccount.com>
kokoro-CI: kokoro <noreply+kokoro@google.com>
| -rw-r--r-- | migrations/000156_add_index_to_module_version_states.down.sql | 9 | ||||
| -rw-r--r-- | migrations/000156_add_index_to_module_version_states.up.sql | 9 |
2 files changed, 18 insertions, 0 deletions
diff --git a/migrations/000156_add_index_to_module_version_states.down.sql b/migrations/000156_add_index_to_module_version_states.down.sql new file mode 100644 index 00000000..91b30bb4 --- /dev/null +++ b/migrations/000156_add_index_to_module_version_states.down.sql @@ -0,0 +1,9 @@ +-- Copyright 2025 The Go Authors. All rights reserved. +-- Use of this source code is governed by a BSD-style +-- license that can be found in the LICENSE file. + +BEGIN; + +DROP INDEX IF EXISTS idx_mvs_unprocessed_timestamp; + +END; diff --git a/migrations/000156_add_index_to_module_version_states.up.sql b/migrations/000156_add_index_to_module_version_states.up.sql new file mode 100644 index 00000000..9b9e6b5c --- /dev/null +++ b/migrations/000156_add_index_to_module_version_states.up.sql @@ -0,0 +1,9 @@ +-- Copyright 2025 The Go Authors. All rights reserved. +-- Use of this source code is governed by a BSD-style +-- license that can be found in the LICENSE file. + +BEGIN; + +CREATE INDEX idx_mvs_unprocessed_timestamp ON module_version_states (index_timestamp) WHERE last_processed_at IS NULL; + +END; |