Re: Where to store Blobs?

From: Hannes Erven <hannes(at)erven(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Where to store Blobs?
Date: 2019-03-13 16:39:38
Message-ID: 111be01e-c8b1-eab0-a87e-d7410ff02789@erven.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Am 13.03.19 um 15:28 schrieb Thomas Güttler:
>
> Where do you store Blobs?

Within PostgreSQL, of course. The system I have in mind stores ZIP and
PDF files, usually a few MBs each; we're currently at a total of about
100 GB and there are no evident problems.

For this application, it is extremely important that saving/modifying
the binaries is part of a larger transaction that completes/fails
atomically.
Replication is almost real-time and access to the binaries is provided
with the same libraries (JDBC/Hibernate) as everything else.

Best regards,

-hannes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jamesie Pic 2019-03-13 17:32:52 Re: Where to store Blobs?
Previous Message Achilleas Mantzios 2019-03-13 16:29:21 Re: Where to store Blobs?