Mercurial > hg > orthanc-book

comparison Sphinx/source/plugins/postgresql.rst @ 94:b0a71b880ca0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix link + remark about disk usage overhead
author Alain Mazy <alain@mazy.be>
date Wed, 08 Mar 2017 10:26:13 +0100
parents 4eea0dc5f071
children a30abf63ccba
comparison
equal deleted inserted replaced
93:a1e55e1baf38 94:b0a71b880ca0
35 * ``OrthancPostgreSQLStorage`` makes Orthanc store the DICOM files it receives into PostgreSQL. 35 * ``OrthancPostgreSQLStorage`` makes Orthanc store the DICOM files it receives into PostgreSQL.
36 36
37 Pre-compiled binaries for Microsoft Windows `are also available 37 Pre-compiled binaries for Microsoft Windows `are also available
38 <http://www.orthanc-server.com/browse.php?path=/plugin-postgresql>`__. 38 <http://www.orthanc-server.com/browse.php?path=/plugin-postgresql>`__.
39 A package for `Apple's Mac OS X 39 A package for `Apple's Mac OS X
40 <http://localhost/~jodogne/orthanc/static.php?page=download-mac>`__ 40 <http://www.osimis.io/en/download.html>`__
41 are available courtesy of `Osimis <http://osimis.io/>`__. 41 are available courtesy of `Osimis <http://osimis.io/>`__.
42 42
43 43
44 Usage 44 Usage
45 ----- 45 -----
79 } 79 }
80 80
81 Note that ``EnableIndex`` and ``EnableStorage`` must be explicitly set 81 Note that ``EnableIndex`` and ``EnableStorage`` must be explicitly set
82 to true, otherwise Orthanc will continue to use its default SQLite 82 to true, otherwise Orthanc will continue to use its default SQLite
83 back-end. 83 back-end.
84
85 **Remark:** When using the ``Storage`` PostgreSQL plugin, the DICOM files are stored as large objects in the database. This actually consumes more space than the DICOM file itself (around 40% more).
86 When dealing with large number of files, it is recommended to continue using the default filesystem storage for DICOM files and enable the ``Index`` PostgreSQL plugin.
84 87
85 .. highlight:: text 88 .. highlight:: text
86 89
87 Orthanc must of course be **restarted** after the modification of its 90 Orthanc must of course be **restarted** after the modification of its
88 configuration file. The log will contain an output similar to:: 91 configuration file. The log will contain an output similar to::