Thanks for your help Ubqtous I have a large 60GB data set of land parcel and related information for NZ which has to be imported from some kind of txt files. One table is apparently 5 GB. The data then needs to be transformed and then accessed via cold fusion on an in house server.
I've seen reviews claiming that MySQL and PostgreSQL fall over at the 100GB limit - so kind of curious about the truth in that. I notice that Macromedia don't include PostgreSQL as a supported database fof Coldfusion MX6.1 Server but Bluedragon do. Hmmm curious Mike NZERN ---------- Original Message ---------------------------------- From: Ubqtous <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 29 Nov 2004 00:15:02 -0500 Perhaps you're looking for testimonials, but according to http://www.postgresql.org/docs/faqs/FAQ.html: 4.5) What is the maximum size for a row, a table, and a database? These are the limits: Maximum size for a database? unlimited (32 TB databases exist) Maximum size for a table? 32 TB Maximum size for a row? 1.6TB Maximum size for a field? 1 GB Maximum number of rows in a table? unlimited Maximum number of columns in a table? 250-1600 depending on column types Maximum number of indexes on a table? unlimited Of course, these are not actually unlimited, but limited to available disk space and memory/swap space. Performance may suffer when these values get unusually large. The maximum table size of 32 TB does not require large file support from the operating system. Large tables are stored as multiple 1 GB files so file system size limits are not important. The maximum table size and maximum number of columns can be quadrupled by increasing the default block size to 32k. On Mon, 29 Nov 2004 15:06:02 +1300, NZERN National Office <[EMAIL PROTECTED]> wrote: > Hi there > > How large a database can PostgreSQL reliably support. I need something that > can store about 100GB -- Ubqtous ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
