Re: How to store "blobs" efficiently for small and large sizes, with random access

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to store "blobs" efficiently for small and large sizes, with random access
Date: 2022-10-20 11:23:00
Message-ID: 39ca6ca6-21c2-4c08-f1e6-912b539e7cea@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/20/22 03:32, Dominique Devienne wrote:
[snip]
> And from the posts here, the issues
> with large blobs may be more
> related to backup/restore perhaps, than runtime performance.

From my long experience as a first a programmer and then a database
administrator, backups and archiving are at the very bottom of programmers'
priority list, whereas they're near the top of a DBA's priority list.

> Having all the data in the DB, under a single security model, is a big
> win for consistency and simplicity.

No doubt.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vince McMahon 2022-10-20 11:58:29 Explain returns different number of rows
Previous Message Karsten Hilbert 2022-10-20 10:38:49 Aw: Re: How to store "blobs" efficiently for small and large sizes, with random access