Performant storage for large string contents

Instead of storing large-object data within a column, as many databases do, PostgreSQL stores them in a dedicated table.

The content server uses the @LOB annotation on the field content to store the content of files. Then, Hibernate maps this field according to database configuration.

Prior experience with PostgreSQL has highlighted performance issues with the Content Server because it uses a lot of searching in the column content. So if the size of the files does not exceed 1GB, we recommend to override the PostgreSQL Dialect and map the LOB field into a varchar column. That way, the field will be mapped to a column and the large-object store will not be used.

An example of how to override a database dialect can be found here.