diff Sphinx/source/plugins/postgresql.rst @ 118:a30abf63ccba

postgres: reference to forum for space usage
author amazy
date Mon, 23 Oct 2017 09:39:56 +0200
parents b0a71b880ca0
children f2abbac22d5c
line wrap: on
line diff
--- a/Sphinx/source/plugins/postgresql.rst	Thu Oct 05 17:06:14 2017 +0200
+++ b/Sphinx/source/plugins/postgresql.rst	Mon Oct 23 09:39:56 2017 +0200
@@ -82,8 +82,11 @@
 to true, otherwise Orthanc will continue to use its default SQLite
 back-end.
 
-**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).  
-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.
+**Remark:** When using the ``Storage`` PostgreSQL plugin, the DICOM files are stored as large objects in the database.  This might actually consume more space than the DICOM file itself.  We have observed overhead up to 40%.  However, it seems this overhead is temporary and comes from Write-Ahead Logging.  Check this `discussion <https://groups.google.com/d/msg/orthanc-users/pPzHOpb--iw/QkKZ808gIgAJ>`__ on the Orthanc Users group for more info).  
+
+Note that a typical usage of the PostgreSQL plugin is to enable only the ``Index`` and continue using the default filesystem storage for DICOM files.
+
+
 
 .. highlight:: text