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

From Christopher Browne
Subject Re: Where to store Blobs?
Date
Msg-id CAFNqd5WhuRSPPoPTR9uw7tD_9o4TqFq=WOBGsEzVs6xTuxcefg@mail.gmail.com
Whole thread Raw
In response to Where to store Blobs?  (Thomas Güttler <guettliml@thomas-guettler.de>)
Responses Re: Where to store Blobs?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On Wed, 13 Mar 2019 at 10:27, Thomas Güttler
<guettliml@thomas-guettler.de> wrote:
> I guess most people do not store Blobs in PostgresSQL.
>
> Where do you store Blobs?

Things have changed, but at one time, we were using RT as our
ticketing system (https://bestpractical.com/request-tracker) and it
would capture documents as database objects.

The table where RT stowed downloadable documents was one of the
largest tables in the database because of there being a few 50MB
copies of Access Databases and some many-MB spreadsheets in there.

It worked fine; no problems evident from it.  It was certainly
surprising to find such large documents there, and if people had
gotten in the habit of putting GBs of data into RT, that would have
probably led to some policy changes to prevent it, but unless you're
pretty actively trying to blow the system up, it just works.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"


pgsql-general by date:

Previous
From: Chuck Martin
Date:
Subject: Re: Where to store Blobs?
Next
From: Karsten Hilbert
Date:
Subject: Re: Where to store Blobs?