Mercurial > hg > orthanc-book

comparison Sphinx/source/faq/scalability.rst @ 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 50bdd7c7e9b9
children 4f3a6145ae34
comparison
equal deleted inserted replaced
531:fcf614950f31 532:034895d2432a
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
101 PostgreSQL database in order to `reclaim the storage space
102 <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
104 cron job).
105
100 * You might also be interested in checking the options related to 106 * You might also be interested in checking the options related to
101 :ref:`security <security>`. 107 :ref:`security <security>`.
102 108
103 * Consider using filesystems that are known to achieve high 109 * Consider using filesystems that are known to achieve high
104 performance, such as `XFS <https://en.wikipedia.org/wiki/XFS>`__ or 110 performance, such as `XFS <https://en.wikipedia.org/wiki/XFS>`__ or