32 to 64 bit change over

View: New views
2 Messages — Rating Filter:   Alert me  

32 to 64 bit change over

by Walter, Carol Williams :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: 32 to 64 bit change over

by Joshua D. Drake :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tue, 26 Aug 2008 15:13:27 -0400
Carol Walter <walterc@...> 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



--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
LightInTheBox - Buy quality products at wholesale price!