Обсуждение: 32 to 64 bit change over
Greetings, one and all, I have some very large memory bound queries being run in postgres. The documentation seems to say that I would be able to get more use out of the available memory if I were running the 64 bit postgres instead of the current 32 bit. We have the binaries for both. What would be the ramifications to changing from the 32 bit to the 64 bit process? Thanks, Carol
On Tue, 26 Aug 2008 15:13:27 -0400 Carol Walter <walterc@indiana.edu> wrote: > Greetings, one and all, > > I have some very large memory bound queries being run in postgres. > The documentation seems to say that I would be able to get more use > out of the available memory if I were running the 64 bit postgres > instead of the current 32 bit. We have the binaries for both. What > would be the ramifications to changing from the 32 bit to the 64 bit > process? You have to dump and reload or use something like Slony to transfer your data to the new cluster. Joshua D. Drake > > Thanks, > Carol > -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate