Re: > 16TB worth of data question

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
Cc: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>, postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: > 16TB worth of data question
Date: 2003-04-22 17:31:22
Message-ID: 20030422173122.GI79923@perrin.int.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> FWIW, FreeBSD's UFS filesystem doesn't suffer from the 2G
> limit. It's limit is something like 4TB iirc.

Actually, on FreeBSD >5.X, you have UFS2 which shatters the 4TB limit.
Now you're limited to 16,777,216TB per file system. Sorry it's not
more. In truth, I wish that limit was higher as I seem to run into it
on a daily basis. ::grumps:: 8-]

> I'll also second the opinion that if you're really going to put that
> much data in your database, x86 hardware might not be a good idea.
> However, I'd recommend RS/6000 over Sun if you can afford it;

There really is something to be said for the architecture of PowerPC's
memory access routines and its scalability... though quirky to build
open source stuff on, AIX is still the grand daddy of *NIXes for this
very reason.

-sc

--
Sean Chittenden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Crercio O. Silva 2003-04-22 17:36:52 New DBTools Manager 2.1
Previous Message Jeff MacDonald 2003-04-22 17:26:58 Re: Time handling in pgsql. (fwd)