Is PostgreSQL a 64-bit database?

[oradba101]

Is PostgreSQL a 64-bit database? If not, is there any plans to make it so?

Thanks,

Bill Chadbourne
Oracle DBA
TCMHS

 

[ceco]

how do you define 64-bit database, anyway you can see here

http://developer.postgresql.org/supported-platforms.html

for the supported platforms it may answer your question

 

[rycamor]

PostgreSQL can be compiled in 64-bit mode an any of the 64-bit architectures in ceco's link. Exactly what that means for performance/size is not always an easy answer. In other words, for some cases, the performance difference between a 32-bit and a 64-bit system might not be that great. Also, PostgreSQL table sizes are not limited by 2GB or 4GB file size limits even on 32-bit systems. And, PostgreSQL has a 64-bit long integer type even on 32-bit systems.

If you browse the

http://archives.postgresql.org/pgsql-performance

mail lists, you will probably find some good information on 64-bit optimization.