Re: Windows x64 Port - Mailing list pgsql-general

From Willem Buitendyk
Subject Re: Windows x64 Port
Date
Msg-id 473B5E76.5050604@pcfish.ca
Whole thread Raw
In response to Re: Windows x64 Port  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Thanks Magnus.  Looking forward to 8.4, but I gather that will be some
time coming.

Willem

Magnus Hagander wrote:
> Willem Buitendyk wrote:
>
>> Is there any plan to port Postgresql to windows x64?  I can currently
>> run Postgresql as 32 bit inside Vista 64 - would I see better
>> performance if Postgresql was running under 64 bit.  My biggest concern
>> is memory - at 32 bit is not Postgresql limited to 4GB in windows?
>>
>
> It's something we hope will be worked on for 8.4, but there are no firm
> plans.
>
> It's limited to 2Gb, actually, but *per process*. Since each backend is
> it's own process, you can use way more than 2Gb RAM on a 64-bit system.
> You can't use it for shared memory, but you can use it for local backend
> memory (work_mem). But you'll need a lot of backends to do it, and you
> will see other pieces of performance get worse with loads of backend.
>
> Oh, and your RAM will still be used for disk cache, since that's managed
> by the kernel.
>
> //Magnus
>
> __________ NOD32 2658 (20071114) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
>


pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: PLpgsql debugger question
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PLpgsql debugger question