I’m not sure if GeoPackage was ever tested/considered during development of ODM as the data storage back-end, but I think it might have a few characteristics that may make it worth considering.
- Dependencies, Dependencies, Dependencies
- Single-File database for Raster/Vector
- Already in-use in the code for vector product storage
This talk gives a decent summary, and even exposes some nice GDAL code to load/save from PG to GPKG.
Please let me know if you already considered this and other factors (clustering, etc.) made it insufficient as a back-end storage.