Mercurial > hg > orthanc-book

changeset 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 feed6ec05f51
children 05a5a7369126
files Sphinx/source/faq/scalability.rst
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
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).