Mercurial > hg > orthanc-book
comparison Sphinx/source/faq/scalability.rst @ 620:0b93fcc8162f
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 |