Clarification on EnableStorage in PostgreSQL settings

General
1

Good day everyone!

We are currently working with around 10TB of data. I would like to clarify how the EnableStorage parameter works in the PostgreSQL configuration.

“PostgreSQL”: {
“EnableIndex”: true,
“EnableStorage”: false
}

According to the documentation, when EnableStorage = true, all data store in DB. I have a few questions:

Does setting EnableStorage = true mean that data is stored locally in PostgreSQL? Is it a good way ?

If EnableStorage = false, does this mean that only indexing is handled via PostgreSQL, and the actual data is not stored in the database.

Any insights or recommendations would be appreciated. Thanks!

2

Hello,

We strongly advise to avoid the storage of the data (DICOM files, i.e the images) in the database.
So to be clear, especially with 10TB of data, this is the best tuning:

“PostgreSQL”: {
“EnableIndex”: true,
“EnableStorage”: false
}

Then, the main DICOM tags will be stored in the Postgres database while the DICOM files will be stored in the dedicated storage (see orthanc: a30cc2fa7250 OrthancServer/Resources/Configuration.json).

HTH,