On Mon, Dec 27, 2004 at 10:39:48 -0600,
Dan Boitnott <dan(at)mcneese(dot)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.
In response to
pgsql-general by date
|Next:||From: Tatsuo Ishii||Date: 2004-12-31 06:55:37|
|Subject: Re: pg_dump and pgpool|
|Previous:||From: Jaime Casanova||Date: 2004-12-31 06:19:05|
|Subject: Re: [PATCHES] reqd patch|