Re: [GENERAL] blob storage

2005-04-26 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Tue, Apr 26, 2005 at 03:41:28PM -0500, Scott Marlowe wrote: >> If you store them as large objects, they will each get their own file. > Huh, no, they won't. They will be stored in the pg_largeobject table. > It's been quite a while since they are no

Re: [GENERAL] blob storage

2005-04-26 Thread Scott Marlowe
On Tue, 2005-04-26 at 16:42, Alvaro Herrera wrote: > On Tue, Apr 26, 2005 at 03:41:28PM -0500, Scott Marlowe wrote: > > 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 t

Re: [GENERAL] blob storage

2005-04-26 Thread Alvaro Herrera
On Tue, Apr 26, 2005 at 03:41:28PM -0500, Scott Marlowe wrote: > 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

Re: [GENERAL] blob storage

2005-04-26 Thread Rich Shepard
On Tue, 26 Apr 2005, 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. T

Re: [GENERAL] blob storage

2005-04-26 Thread Joshua D. Drake
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, Either as bytea or a large object. if it is all in one file, or if each blob is sored in i

Re: [GENERAL] blob storage

2005-04-26 Thread Scott Marlowe
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

[GENERAL] blob storage

2005-04-26 Thread Travis Harris
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