Re: orthanc-postgresql

[Sébastien Jodogne <s.jodogne@chu.ulg.ac.be>]

> Delightedly I have noted that PG can be used to store both of
> index _and_ the actual DICOM instances (?).

Yes, you're right: Enabling the "libOrthancPostgreSQLStorage.so" will store the DICOM instances into PostgreSQL (and not on the filesystem).


> If so, I'd be interested to know which way you chose to store
> DICOM instances inside PG -- by means of BYTEA columns or as
> large objects ?
> 
> 	http://www.postgresql.org/docs/9.4/static/datatype-binary.html
> 	http://www.postgresql.org/docs/9.4/static/largeobjects.html
> 
> (that'll influence recommendations regarding
> backup/restore/failover)

The plugin uses large objects.