Re: > 16TB worth of data question

From: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: > 16TB worth of data question
Date: 2003-04-21 18:46:28
Message-ID: 1050950788.4188.94.camel@bluejay.goodinassociates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)cs(dot)earlham(dot)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(at)postgresql(dot)org
--
Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Nuzum 2003-04-21 18:53:25 postgres discussed at php.weblogs.com
Previous Message Paul Ramsey 2003-04-21 18:45:20 Re: > 16TB worth of data question