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

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: 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 07:57:06
Message-ID: CAFCRh-_bY1wLegyBVFXQAK4GvMmtGP3svc17qhyg9smAVDWLEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 19, 2022 at 4:29 PM Daniel Verite <daniel(at)manitou-mail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2022-10-20 08:00:08 Re: How to store "blobs" efficiently for small and large sizes, with random access
Previous Message Frank Gard 2022-10-20 07:38:48 Re: pg_restore 12 "permission denied for schema" errors