migrations: Add state and lock_id as indices on the replication_queue tablejc-add-replication-queue-indices

1 files changed, 20 insertions, 0 deletions

diff --git a/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go b/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go
new file mode 100644
index 000000000..549db4dff
--- /dev/null
+++ b/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go
@@ -0,0 +1,20 @@
+package migrations
+
+import migrate "github.com/rubenv/sql-migrate"
+
+func init() {
+	m := &migrate.Migration{
+		Id: "20220214202822_replication_queue_state_lock_id_indices",
+		Up: []string{
+			"CREATE INDEX CONCURRENTLY replication_queue_lock_id ON replication_queue (lock_id)",
+			"CREATE INDEX CONCURRENTLY replication_queue_state ON replication_queue (state)",
+		},
+		DisableTransactionUp: true,
+		Down: []string{
+			"DROP INDEX replication_queue_state",
+			"DROP INDEX replication_queue_lock_id",
+		},
+	}
+
+	allMigrations = append(allMigrations, m)
+}