Re: blob storage

On Tue, 2005-04-26 at 15:30, Travis Harris wrote:
> I would like to use P* to store files. These files will probably
> range from 500K to 2 MB in size and there will be thousands upon
> thousands of them. I was wondering how P* stores blobs, if it is all
> in one file, or if each blob is sored in it's own file. The reason
> being, I know that windows has a 2 GB limit on files, and if they are
> not stored as their own files, I'll hit my limit FAST... and it'll do
> me no good... If this is going to be a problem, does anyone have any
> suggestions?

If you store them as large objects, they will each get their own file.

However, you can also store them as rows in a bytea field, and
postgresql will split the table every 1 gig or so automagically.

lo is generally faster but less "database like" and more like a file
system interface while bytea tends to have more overhead due to escaping
/ encoding needed to be done before storage and upon retrieval.