diff options
Diffstat (limited to 'internal/praefect/datastore/repository_store.go')
-rw-r--r-- | internal/praefect/datastore/repository_store.go | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/internal/praefect/datastore/repository_store.go b/internal/praefect/datastore/repository_store.go index cdacca0e8..b9ee33ba3 100644 --- a/internal/praefect/datastore/repository_store.go +++ b/internal/praefect/datastore/repository_store.go @@ -670,10 +670,6 @@ func (rs *PostgresRepositoryStore) GetPartiallyAvailableRepositories(ctx context // than the assigned ones. // rows, err := rs.db.QueryContext(ctx, ` -WITH valid_primaries AS MATERIALIZED ( - SELECT repository_id, storage FROM valid_primaries -) - SELECT json_build_object ( 'RelativePath', relative_path, @@ -711,7 +707,7 @@ FROM ( ) AS repository_assignments USING (repository_id, storage) JOIN repositories USING (repository_id) LEFT JOIN healthy_storages USING (virtual_storage, storage) - LEFT JOIN valid_primaries USING (repository_id, storage) + LEFT JOIN ( SELECT repository_id, storage FROM valid_primaries ) AS valid_primaries USING (repository_id, storage) WHERE virtual_storage = $1 ORDER BY relative_path, "primary", storage ) AS outdated_repositories |