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:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 2:15 PM To: Bradley Kieser Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Do Petabyte storage solutions exist? ----- Original Message ----- From: "Bradley Kieser" <[EMAIL PROTECTED]> To: "Tony Reina" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
