Thread: 32 to 64 bit change over

32 to 64 bit change over

From
Carol Walter
Date:
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

Re: 32 to 64 bit change over

From
Joshua Drake
Date:
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