Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

autovacuum tuning with long transactions #42

Open
zadykian opened this issue Jun 6, 2021 · 0 comments
Open

autovacuum tuning with long transactions #42

zadykian opened this issue Jun 6, 2021 · 0 comments
Assignees
Labels
feature New functionality

Comments

@zadykian
Copy link
Owner

zadykian commented Jun 6, 2021

In the current implementation existence of long transactions is not taken into account during autovacuum-related parameters tuning.
This can cause useless or even harmful increasing of autovacuum intensity.
To deal with such cases, the oldest active transaction id should be logged with average bloat fraction.
And it case when bloat fraction is increasing, but the txid stays the same, autovacuum configuration shouldn't be changed.

@zadykian zadykian added the feature New functionality label Jun 6, 2021
@zadykian zadykian self-assigned this Jun 6, 2021
@zadykian zadykian changed the title feature/autovacuum-tuning-long-transactions autovacuum tuning with long transactions Jun 9, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New functionality
Projects
None yet
Development

No branches or pull requests

1 participant