Mercurial > hg > orthanc-book

diff Sphinx/source/faq/scalability.rst @ 620:0b93fcc8162f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
note about autovacuum in postgresql
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 26 Feb 2021 08:35:52 +0100
parents cfeb018b9150
children b6ac092360ab
line wrap: on
line diff
--- 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
   <https://wiki.postgresql.org/wiki/Performance_Optimization>`__.
 
-* 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
+  <https://www.postgresql.org/docs/current/routine-vacuuming.html>`__
+  of PostgreSQL, or to periodically run the ``VACUUM`` SQL command on
+  the PostgreSQL database in order to `reclaim the storage space
   <https://www.postgresql.org/docs/current/sql-vacuum.html>`__ that is
   occupied by rows that have been deleted from the database (e.g. in a
   cron job).