From 1f416291f52e14c9c0721e9d6ed13fa6a4c2d127 Mon Sep 17 00:00:00 2001 From: John Cai Date: Mon, 14 Feb 2022 16:50:45 -0500 Subject: [PATCH] migrations: Add state and lock_id as indices on the replication_queue table --- ...replication_queue_state_lock_id_indices.go | 20 +++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go 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 00000000000..549db4dffa3 --- /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) +} -- GitLab