Re: Do Petabyte storage solutions exist? - Mailing list pgsql-admin

From Goulet, Dick
Subject Re: Do Petabyte storage solutions exist?
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA6506D968@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to Do Petabyte storage solutions exist?  (reina_ga@hotmail.com (Tony Reina))
List pgsql-admin
Yeah, move on over to Oracle.  Even on older versions the file limit may have been 2GB, but a tablespace could have
morethan one datafile.  The true limit there is 4194303 blocks where a block can be 2KB, 4KB, 8KB, 16KB, 32KB, 64KB and
with10G comes 128KB. Then each table/index can have 4194303 segments which are user definable up to the max size of a
datafile. Now if you've a 64KB block size database that means you can have one segment as a max of 262,144 bytes &
sinceyou can have 4194303 of those the max possible size of a table is 1,099,511,365,632 MB.  And if that ain't big
enoughfor you, turn on partitioning.  Truly the sky IS the limit. 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Tony and Bryn Reina [mailto:reina_ga@hotmail.com]
Sent: Thursday, April 01, 2004 2:15 PM
To: Bradley Kieser
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Do Petabyte storage solutions exist?



----- Original Message -----
From: "Bradley Kieser" <brad@kieser.net>
To: "Tony Reina" <reina_ga@hotmail.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, April 01, 2004 8:53 PM
Subject: Re: [ADMIN] Do Petabyte storage solutions exist?


 let alone the storate limit of 2GB per
> table. So sadly, PG would have to bow out of this IMHO unless someone
> else nukes me on this!

Uh oh, 2 GB limit on table sizes. I did realize the limit was that low.

Would commercial DBMS be the better solution for handling Terabyte databases
and above?


-Tony

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: "Tony and Bryn Reina"
Date:
Subject: Re: Do Petabyte storage solutions exist?
Next
From: Jürgen Cappel
Date:
Subject: Re: Do Petabyte storage solutions exist?