Re: > 16TB worth of data question

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

Sorry, for got a little info. A few years from now, I'd still like to be
able to luse my old servers for a bit of load balancing..

-jj-

On Mon, 2003-04-21 at 13:38, Neil Conway wrote:
> On Mon, 2003-04-21 at 14:23, Jeremiah Jahn wrote:
> > 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.
>
> I'm not sure why the 16TB limit you refer to would be a problem in the
> short to medium term, if you're only storing 2TB/year.
>
> > 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
>
> FWIW, storing the FS location in the database is by no means
> complicated. I'm personally not very fond of doing that, but not because
> it's overly complex...
>
> Cheers,
>
> Neil
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-04-21 19:03:12 Re: > 16TB worth of data question
Previous Message Matthew Nuzum 2003-04-21 18:53:25 postgres discussed at php.weblogs.com