Re: Where to store Blobs? - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Where to store Blobs?
Date
Msg-id 45736ca5-a941-c9bc-6567-623e989dd8ee@matrix.gatewaynet.com
Whole thread Raw
In response to Where to store Blobs?  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-general
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
happensin 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



pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Where to store Blobs?
Next
From: Hannes Erven
Date:
Subject: Re: Where to store Blobs?