Re: > 16TB worth of data question

Notice the plus sign in that 2TB+. I have reason to belive that I could
hit that mark in a little over 2 years. What do you think the chances of
Linux 2.6 are of stablizing in that time frame.. ;) I'm just questioning
the use of BLOB's really. It would be nice if they could be spread over
multiple file systems.


-jj-

On Mon, 2003-04-21 at 13:28, Doug McNaught wrote:
> Jeremiah Jahn <jeremiah@cs.earlham.edu> writes:
>
> > I have a system that will store about 2TB+ of images per year in a PG
> > database. Linux unfortunatly has the 16TB limit for 32bit systems. Not
> > really sure what should be done here. Would life better to not store the
> > images as BLOBS, and instead come up with some complicated way to only
> > store the location in the database, or is there someway to have postgres
> > handle this somehow? What are other people out there doing about this
> > sort of thing?
>
> Sounds to me as if you can ignore it for now.  16TB will last you at
> least four years, at which time you'll be replacing hardware anyway
> and can just buy 64-bit systems.
>
> :)
>
> -Doug
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Jeremiah Jahn <jeremiah@cs.earlham.edu>