Mercurial > hg > orthanc-book

comparison 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
comparison
equal deleted inserted replaced
619:feed6ec05f51 620:0b93fcc8162f
95 very important information regarding performance. 95 very important information regarding performance.
96 96
97 * Make sure to read guides about the `tuning of PostgreSQL 97 * Make sure to read guides about the `tuning of PostgreSQL
98 <https://wiki.postgresql.org/wiki/Performance_Optimization>`__. 98 <https://wiki.postgresql.org/wiki/Performance_Optimization>`__.
99 99
100 * Make sure to periodically run the ``VACUUM`` SQL command on the 100 * Make sure to enable the `Autovacuum Daemon
101 PostgreSQL database in order to `reclaim the storage space 101 <https://www.postgresql.org/docs/current/routine-vacuuming.html>`__
102 of PostgreSQL, or to periodically run the ``VACUUM`` SQL command on
103 the PostgreSQL database in order to `reclaim the storage space
102 <https://www.postgresql.org/docs/current/sql-vacuum.html>`__ that is 104 <https://www.postgresql.org/docs/current/sql-vacuum.html>`__ that is
103 occupied by rows that have been deleted from the database (e.g. in a 105 occupied by rows that have been deleted from the database (e.g. in a
104 cron job). 106 cron job).
105 107
106 * You might also be interested in checking the options related to 108 * You might also be interested in checking the options related to