(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.)
（我已经阅读了很多关于64位与32位OS / Apps的内容，但这个问题专门针对数据库。）
I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and namely, under what conditions that it starts to make sense to use 64-bit installations.
我试图了解32位与64位数据库的优缺点，即在什么条件下使用64位安装才有意义。
The database systems that I am interested in are: SQL Server 2008, MySQL, and PostgreSQL 9.0.
我感兴趣的数据库系统是：SQL Server 2008，MySQL和PostgreSQL 9.0。
I have read that pre-9.0 versions of PostgreSQL only comes in 32-bit for Windows, and this article about running 32-bit PostgreSQL on 64-bit Windows clears up some of my confusion, but I'm looking for more info.
我已经读过，PostgreSQL的9.0之前的版本仅适用于Windows的32位版本，而这篇关于在64位Windows上运行32位PostgreSQL的文章清除了我的一些困惑，但我正在寻找更多信息。
When would I benefit from using 64-bit databases (i.e. database size/disk space, available system memory, types of data sernarios that are known to benefit from it, which database engine being used, etc.)?
我何时可以从使用64位数据库中受益（即数据库大小/磁盘空间，可用系统内存，已知可从中受益的数据类型，使用哪种数据库引擎等）？
1 个解决方案
#1
4
Assuming you have a 64-bit capable OS and processor, the most important advantage of 64-bits is the ability to use more than 4GB of memory.
假设你有一个64位的操作系统和处理器，64位最重要的优势是能够使用超过4GB的内存。
#1
4
Assuming you have a 64-bit capable OS and processor, the most important advantage of 64-bits is the ability to use more than 4GB of memory.
假设你有一个64位的操作系统和处理器，64位最重要的优势是能够使用超过4GB的内存。