provide mechanism to throttle batched background migrations

Release notes

Problem to solve

Customers running PostgreSQL on AWS (RDS) can run into performance issues that can be tracked back to high IO exhausting buffer credits / burst balance.

Database migrations can cause a lot of IO (including autovacuum!) and we have seen a correlation with upgrades; or in some cases direct causation has been confirmed.

Deliverable

• Batch efficiency is configurable by administrators
• A note is added to the External Databases Troubleshooting Section

Proposal

Provide an environment variable or application setting to throttle back BBMs using TARGET_EFFICIENCY in the batch optimizer

Intended users

Folks who support GitLab environments.

• Priyanka (Platform Engineer)
• Sidney (Systems Administrator)
• Isaac (Infrastructure Engineer)

Feature Usage Metrics

Does this feature require an audit event?

If implemented as an application setting, then probably: yes. But I don't think it requires it.

This page may contain information related to upcoming products, features and functionality. It is important to note that the information presented is for informational purposes only, so please do not rely on the information for purchasing or planning purposes. Just like with all projects, the items mentioned on the page are subject to change or delay, and the development, release, and timing of any products, features, or functionality remain at the sole discretion of GitLab Inc.