Re: > 16TB worth of data question - Mailing list pgsql-general

From Doug McNaught
Subject Re: > 16TB worth of data question
Date
Msg-id m3fzob1z9j.fsf@varsoon.wireboard.com
Whole thread Raw
In response to > 16TB worth of data question  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Responses Re: > 16TB worth of data question  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeremiah Jahn
Date:
Subject: > 16TB worth of data question
Next
From: Neil Conway
Date:
Subject: Re: > 16TB worth of data question