GoogleCloudPlatform/spanner-migration-tool

Defer secondary index creation based on flag

Open

#292 opened on May 9, 2022

View on GitHub
 (0 comments) (0 reactions) (0 assignees)PLpgSQL (81 forks)auto 404
good first issue

Repository metrics

Stars
 (152 stars)
PR merge metrics
 (PR metrics pending)

Description

Currently, we create secondary indexes with the schema before hand. We want to add a flag so that it can be deferred and created after data migration is complete. This is useful when the number of secondary indexes are very high and creating them before can slow down the data migration.

Contributor guide

Research direction
Investigate the current secondary index creation logic in the migration tool, identify where indexes are created with the schema, and add a flag to defer index creation after data migration. Implement the flag and ensure it works correctly.
Tech stack
None
Domain
databasebackend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Database migration concepts
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75