What size barrier? MySQL's size limit was Linux kernel limitation in the size of a file (2 GB). PostgreSQL suffered from the same limitation. That restriction went away with the 2.4 kernel. The limit is 2^32 blocks. If you're using 2K or 4K blocks, that's a pretty big file (4096 X 2^32 = 17,592,186,044,416) or 17 Terabytes. MySQL's limit is smaller than that. In fact, according to the folks at MySQL, it scales to very large files better than Oracle does. MySQL has made major changes when going to 4.0. In fact, if you install it, you need to recomile anything that uses shared libraries to access it.
However, MySQL makes their benchmarking software availabel on their website and you can do your own comparison. see http://www.eweek.com/article2/0,3959,293,00.asp http://www.innodb.com/bench.html Curtis On Sat, 29 Mar 2003, lou wrote: > In some email I received from Jan Pavlík <[EMAIL PROTECTED]> on Fri, 28 Mar > 2003 > 00:29:01 +0100, wrote: > > > No flame, and read :)) > > > > http://www.mysql.com/doc/en/MySQL-PostgreSQL_features.html > > http://www.mysql.com/doc/en/MySQL-PostgreSQL_benchmarks.html > > http://www.mysql.com/information/benchmarks.html > > > If I were you I`ll try a more unbiased opinion, since half of this stuff is > not proven, > considering the different concepts of mysql and postgresql, there are certain > differences, > but definitely these links wont clear the mist. > or mysql. somehow they forgot to mention the db size barrier in there, > pointer size blah > blah.. and the 16 years of pgsql development.. > Considering the fact that there is no such thing as unbiased comparison. > > actually > > best see for yourself. > http://www.google.com/search?q=postgres+vs+mysql&btnG=Google+Search > > > > > cheers > > > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com
