# HG changeset patch # User Sebastien Jodogne # Date 1614324952 -3600 # Node ID 0b93fcc8162f2008a163bdcf45adcb13322b2ab9 # Parent feed6ec05f51c1b1958d140aa2c440cb85a78743 note about autovacuum in postgresql diff -r feed6ec05f51 -r 0b93fcc8162f Sphinx/source/faq/scalability.rst --- a/Sphinx/source/faq/scalability.rst Thu Feb 25 19:06:09 2021 +0100 +++ b/Sphinx/source/faq/scalability.rst Fri Feb 26 08:35:52 2021 +0100 @@ -97,8 +97,10 @@ * Make sure to read guides about the `tuning of PostgreSQL `__. -* Make sure to periodically run the ``VACUUM`` SQL command on the - PostgreSQL database in order to `reclaim the storage space +* Make sure to enable the `Autovacuum Daemon + `__ + of PostgreSQL, or to periodically run the ``VACUUM`` SQL command on + the PostgreSQL database in order to `reclaim the storage space `__ that is occupied by rows that have been deleted from the database (e.g. in a cron job).