On 5/5/2017 11:28 AM, Peter J. Holzer wrote:
On 2017-05-04 23:08:25 +0200, Sven R. Kunze wrote:
On 03.05.2017 12:57, Thomas Güttler wrote:
Am 02.05.2017 um 05:43 schrieb Jeff Janes:
No. You can certainly use PostgreSQL to store blobs. But then, you
need to store the PostgreSQL data **someplace**.
If you don't store it in S3, you have to store it somewhere else.
I don't understand what you mean here. AFAIK storing blobs in PG is not
recommended since it is not very efficient.
Seems like several people here disagree with this conventional wisdom.
I think it depends very much on what level of "efficiency" you need. On
my home server (i5 processor, 32GB RAM, Samsung 850 SSD - not a piece of
junk, but not super powerful either) I can retrieve a small blob from a
100GB table in about 0.1 ms, and for large blobs the speed approaches
200MB/s. For just about everything I'd do on that server (or even at
work) this is easily fast enough.
S3 is often used for terabyte to petabyte file collections. I would not want to burden my relational database with this.
--
john r pierce, recycling bits in santa cruz