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

Support for database vacuuming #42

Closed
denis-stepanov opened this issue Sep 19, 2022 · 2 comments · Fixed by #62
Closed

Support for database vacuuming #42

denis-stepanov opened this issue Sep 19, 2022 · 2 comments · Fixed by #62
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@denis-stepanov
Copy link
Owner

The database of fingerprints even of a modest size can easily have hundreds of thousands of entries. They are intensively queried by parallel threads. It is thus important to keep database small and clean to the extent possible. Manipulating database like pulling an update contributes to buildup of junk which can be removed by PostgreSQL VACUUM command. Experience shows that it may significantly improve performance. It is thus suggested to add its support to the database service tool.

@denis-stepanov denis-stepanov added the enhancement New feature or request label Sep 19, 2022
@denis-stepanov denis-stepanov added this to the v1.5.0 milestone Sep 21, 2022
@denis-stepanov
Copy link
Owner Author

Maybe a better alternative would be to turn on and tune the 'autovacuum' feature of Postgres.

@denis-stepanov
Copy link
Owner Author

It turns out that "autovacuum" is already turned on by default, but it kick in whenever PostgreSQL sees fit, and not necessarily by the end of data modifications. So the vacuum command would still make sense.

An optional -f parameter could perform VACUUM FULL.

@denis-stepanov denis-stepanov self-assigned this Dec 19, 2022
@denis-stepanov denis-stepanov linked a pull request Dec 20, 2022 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant