I was looking at Orthanc PACS and had some questions about other people’s experiences using PostgreSQL setup.
Have you used in-database storage plugin. What did that do to memory consumption of Postgres for your given number of studies/files?
What are the PACS size limitation when using PostgreSQL file storage. Looking at the orthanc schema it looks like text data type is used to store tag values. Then looking at postgres documentation, https://wiki.postgresql.org/wiki/BinaryFilesInDB, it looks like the limitations are 4 billion records when entry exceeds 2KB. So a single image with pixel data tag will reduce 4 billion record count by 1, and an RT Structure Set with, say 1000 contours where each contour decimal string entry > 2K will reduce count by 1000. Is that correct?
In your experience when storing files in DB, is hot backup possible? That is Orthanc continues to recieve/send files while Postgres backup is happening?
Is there a description of filesystem layout? For example I see the DICOM files I sent in various folders, but there are extra smaller files that don’t appear to be DICOM (dcmdump complains for example). What are those?
Thank you very much.