Re: Do Petabyte storage solutions exist?

Yeah, move on over to Oracle. Even on older versions the file limit may have been 2GB, but a tablespace could have more than one datafile. The true limit there is 4194303 blocks where a block can be 2KB, 4KB, 8KB, 16KB, 32KB, 64KB and with 10G 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 & since you 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 enough for 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(at)hotmail(dot)com]
Sent: Thursday, April 01, 2004 2:15 PM
To: Bradley Kieser
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Do Petabyte storage solutions exist?

----- Original Message -----
From: "Bradley Kieser" <brad(at)kieser(dot)net>
To: "Tony Reina" <reina_ga(at)hotmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly