pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
32 to 64 bit change over 2+ messages / 2 participants [nested] [flat]
* 32 to 64 bit change over @ 2008-08-26 19:13 Carol Walter <walterc@indiana.edu> 2008-08-26 19:17 ` Re: 32 to 64 bit change over Joshua Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Carol Walter @ 2008-08-26 19:13 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 32 to 64 bit change over 2008-08-26 19:13 32 to 64 bit change over Carol Walter <walterc@indiana.edu> @ 2008-08-26 19:17 ` Joshua Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua Drake @ 2008-08-26 19:17 UTC (permalink / raw) To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-26 19:17 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-08-26 19:13 32 to 64 bit change over Carol Walter <walterc@indiana.edu> 2008-08-26 19:17 ` Joshua Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox