From: | Andrei Kovalevski <andyk(at)commandprompt(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Willem Buitendyk <willem(at)pcfish(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Windows x64 Port |
Date: | 2007-11-14 20:10:28 |
Message-ID: | 473B5634.5000702@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
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.
>
I'm wondering - what kind of problems do you expect with such port? By
the way, are there any benchmark results to compare 32 and 64 bit
version on Linux?
Thanks,
Andrei.
From | Date | Subject | |
---|---|---|---|
Next Message | SHARMILA JOTHIRAJAH | 2007-11-14 20:18:18 | Re: pg_dump problem |
Previous Message | Tom Lane | 2007-11-14 20:04:43 | Re: psql Segmentation fault |