# HG changeset patch # User Sebastien Jodogne # Date 1603218663 -7200 # Node ID 034895d2432a58a16efeb12545378ff3b7e56732 # Parent fcf614950f31336b1bb15bea006f7061e0e081ab vacuum diff -r fcf614950f31 -r 034895d2432a Sphinx/source/faq/scalability.rst --- a/Sphinx/source/faq/scalability.rst Tue Oct 20 16:26:28 2020 +0200 +++ b/Sphinx/source/faq/scalability.rst Tue Oct 20 20:31:03 2020 +0200 @@ -97,6 +97,12 @@ * 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 + `__ that is + occupied by rows that have been deleted from the database (e.g. in a + cron job). + * You might also be interested in checking the options related to :ref:`security `.