blob storage

From: Travis Harris <trex005(dot)junk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: blob storage
Date: 2005-04-26 20:30:18
Message-ID: fa1b3e8305042613305d8808e9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2005-04-26 20:39:38 Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Previous Message Mohan, Ross 2005-04-26 20:27:33 Re: UltraSPARC versus AMD - Slowaris