On Mon, Mar 02, 2015 at 01:59:41PM +0100, Sébastien Jodogne wrote: > > 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).
That makes it a lot easier to take consistent backups. > > 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 > > The plugin uses large objects. OK, good. That way they can be up to 4 TB in size (as opposed to 1 GB of BYTEA). http://michael.otacoo.com/postgresql-2/playing-with-large-objects-in-postgres/ Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- To UNSUBSCRIBE, email to debian-med-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/20150302131556.gf11...@hermes.hilbert.loc
