Postgres Pro
Downloads
Home   >   mailing lists

Re: How to store "blobs" efficiently for small and large sizes, with random access - Mailing list pgsql-general

From Dominique Devienne
Subject Re: How to store "blobs" efficiently for small and large sizes, with random access
Date
Msg-id CAFCRh-_bY1wLegyBVFXQAK4GvMmtGP3svc17qhyg9smAVDWLEg@mail.gmail.com
Whole thread Raw
In response to Re: How to store "blobs" efficiently for small and large sizes, with random access  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Tree view 
On Wed, Oct 19, 2022 at 4:29 PM Daniel Verite <daniel@manitou-mail.org> wrote:
> In your case I would probably opt for bytea (as opposed to large
> objects), and slicing the blobs in the application in chunks

Thanks for the advice, and the valuable info on LO permissions. --DD

pgsql-general by date:

Previous
From: Frank Gard
Date:
Subject: Re: pg_restore 12 "permission denied for schema" errors
Next
From: Dominique Devienne
Date:
Subject: Re: How to store "blobs" efficiently for small and large sizes, with random access