Re: PDF files: to store in database or not

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PDF files: to store in database or not
Date: 2016-12-08 16:12:55
Message-ID: alpine.LNX.2.11.1612080811440.4562@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 8 Dec 2016, Chris Travers wrote:

> Assuming relatively small files, bytea makes much more sense than a large
> object.

Hi Chris,

Most of the documents are only a few pages in size.

> LOBs work best when you need a streaming interface (seek and friends) while
> bytea's are otherwise much more pleasant to work with.

They're not referenced frequently, only occasionally.

Thanks,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edilmar LISTAS 2016-12-08 20:16:11 Re: How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6
Previous Message John DeSoi 2016-12-08 16:11:12 Re: PDF files: to store in database or not