Search Postgresql Archives

Re: blob storage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 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.
> 
> Huh, no, they won't.  They will be stored in the pg_largeobject table.
> It's been quite a while since they are not stored in separate files;
> though they keep the POSIX-filesystem-like semantics.

Oh, I guess it's been a few years since I last played with large
objects.  Sorry for the misinformation.

I guess you can tell I prefer bytea nowadays...  :)

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux