Re: Large Objects

On Mon, Dec 27, 2004 at 10:39:48 -0600,
  Dan Boitnott <dan@mcneese.edu> wrote:
> I need to do some investigation into the way Postgres handles large
> objects for a major project involving large objects.  My questions are:

I don't know the answer to all of your questions.

>    * Is it practical/desirable to store files MIME-Encoded inside a
> text field?

This should be possible if the files aren't too large. bytea is another type
that might be better to use.

>       * The obvious disadvantages:
>          * slow, Slow, SLOW

If you always need to access the whole file this might not be too bad.
But if you only need to access a small part, you are going to pay a big
cost as the whole record will need to be retrieved before you can pick
out the part you want.

>          * significant increase in per-file storage requirements

It might not be too bad as large records can be compressed. That should get
back some of the bloat from uuencoding.