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
