blob storage - Mailing list pgsql-general

From Travis Harris
Subject blob storage
Date
Msg-id fa1b3e8305042613305d8808e9@mail.gmail.com
Whole thread Raw
Responses Re: blob storage  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: blob storage  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: blob storage  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
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?

pgsql-general by date:

Previous
From: "Mohan, Ross"
Date:
Subject: Re: UltraSPARC versus AMD - Slowaris
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: PRIMARY KEY on a *group* of columns imply that each column is NOT