Re: Where to store Blobs?

From: Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com>
To: Jamesie Pic <jpic(at)yourlabs(dot)org>
Cc: Hannes Erven <hannes(at)erven(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Where to store Blobs?
Date: 2019-03-13 20:47:35
Message-ID: CAD+mzozNXmRKksUOtG0sxcaUONXk8E2w2NPwqxpvGVgsuhF+tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I store large models in the database because I need to have a historical
data to compare to. That said, I could probably also automate a git repo
but it will be just that much more work and git with binary files really
doesn't make sense. Storage is really cheap and I assume the database
stores bytesa types like they do text within a separate and partitioned
section of the database.

Thanks,
~Ben

On Wed, Mar 13, 2019 at 1:37 PM Jamesie Pic <jpic(at)yourlabs(dot)org> wrote:

> Make dump/restore of database data unnecessarily expensive in terms of
> time and space imho.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Cross 2019-03-13 21:14:38 Re: Where to store Blobs?
Previous Message Adrian Klaver 2019-03-13 19:23:31 Re: Autovacuum Transaction Wraparound