Hi everyone,
I wanted to ask for advice on how to optimize the storage space which as you can see from the attached image is almost 6TB.
If I set the compression the space is reduced a lot but orthanc slows down a lot when loading exams from the modes to orthanc so I am forced to disable the compression.
What worries me most is the space of the Postgres DB which arrived with these exams loaded at 34GB.
How is it possible to reduce the space occupied in order to have a much leaner and lighter DB?
I am aware that there is no magic wand to reduce space if not using compression which unfortunately gives me some problems. I will do some tests to understand if and how to improve the Server.
What is very strange to me is the space occupied by the DB which has reached about 34GB. I read that all the information of the DICOM files is saved in the DB but I do not know if there is the possibility of modifying this option in order to improve it and save only the main and most useful data.
That’s the price to pay to be able to search for data and have decent performances in viewers and through the Rest API in general. We consider that the DB size is usually between 0.5% and 1% of the disk storage.
Note that, in future versions, the DB size will grow even more since we are actually adding new indexes and columns to improve performances and add new features.
