PostgreSQL for 64 Bit Windows Version

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

PostgreSQL for 64 Bit Windows Version

by A.Bhattacharya :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hello All,

 

Can anybody help me on downloading 64 bit version of PostgreSQL for Windows environment? Do PostgreSQL for windows version supports 64 bit version?

 

Many thanks

 

 

 


Re: PostgreSQL for 64 Bit Windows Version

by John R Pierce :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

A.Bhattacharya@... wrote:
>
> Hello All,
>
>  
>
> Can anybody help me on downloading 64 bit version of PostgreSQL for
> Windows environment? Do PostgreSQL for windows version supports 64 bit
> version?
>

I don't believe anyone is building a standard package for Win64..    
The 32bit version will work just fine on 64bit windows.



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

Re: PostgreSQL for 64 Bit Windows Version

by Craig Ringer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On 6/11/2009 3:04 PM, John R Pierce wrote:

> I don't believe anyone is building a standard package for Win64..    
> The 32bit version will work just fine on 64bit windows.

... so long as you don't need 2GB (or close to it) of shared memory.

Is anybody using Pg on windows with an installation of that scale yet?

--
Craig Ringer

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

Re: PostgreSQL for 64 Bit Windows Version

by Tom Lane-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Craig Ringer <craig@...> writes:
> On 6/11/2009 3:04 PM, John R Pierce wrote:
>> I don't believe anyone is building a standard package for Win64..    
>> The 32bit version will work just fine on 64bit windows.

> ... so long as you don't need 2GB (or close to it) of shared memory.

> Is anybody using Pg on windows with an installation of that scale yet?

The reports that I've heard say that very large amounts of shared memory
don't seem to offer performance improvements on Windows like you can get
on Unix, so there isn't much reason to put in the (large amount of) work
that would be needed to produce a native Win64 version.

The exact reasons why Windows doesn't like large shmem aren't clear,
at least not to me.

                        regards, tom lane

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

Re: PostgreSQL for 64 Bit Windows Version

by Magnus Hagander-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2009/11/6 Tom Lane <tgl@...>:

> Craig Ringer <craig@...> writes:
>> On 6/11/2009 3:04 PM, John R Pierce wrote:
>>> I don't believe anyone is building a standard package for Win64..
>>> The 32bit version will work just fine on 64bit windows.
>
>> ... so long as you don't need 2GB (or close to it) of shared memory.
>
>> Is anybody using Pg on windows with an installation of that scale yet?
>
> The reports that I've heard say that very large amounts of shared memory
> don't seem to offer performance improvements on Windows like you can get
> on Unix, so there isn't much reason to put in the (large amount of) work
> that would be needed to produce a native Win64 version.

True. I've definitely seen installations with 16Gb or so RAM, but
they're all running with <1Gb shared_buffers.

The reason they'd be interested in Win64 is really to be able to push
up work_mem and maintenance_work_me.


> The exact reasons why Windows doesn't like large shmem aren't clear,
> at least not to me.

Yeah, and also not why it doesn't *always* dislike it.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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