On 13/3/19 4:28 μ.μ., Thomas Güttler wrote:
Some days ago I asked "Where **not** to use PostgreSQL?" on this mailing list.
Where do you store Blobs?
(In my case Blobs are PDF/image files with size up to 20 MByte.
I do not talk about very big blobs which are several hundret MByte)
bytea. Keeping those in the filesys and trying to keep filesys in sync with the db is a PITA. Also dont know what happens in the transactional dept (ACID) with lo_* large objects. In most cases bytea
are just fine.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
