| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Where to store Blobs? |
| Date: | 2019-03-13 16:29:21 |
| Message-ID: | 45736ca5-a941-c9bc-6567-623e989dd8ee@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Erven | 2019-03-13 16:39:38 | Re: Where to store Blobs? |
| Previous Message | Karsten Hilbert | 2019-03-13 15:55:25 | Re: Where to store Blobs? |