Mercurial > hg > orthanc-book
comparison Sphinx/source/faq/scalability.rst @ 532:034895d2432a
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 |