Mercurial > hg > orthanc-book

changeset 532:034895d2432a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vacuum
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Oct 2020 20:31:03 +0200
parents fcf614950f31
children 610e6be26a71
files Sphinx/source/faq/scalability.rst
diffstat 1 files changed, 6 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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
   <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
+  <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).
+
 * You might also be interested in checking the options related to
   :ref:`security <security>`.