Re: pg on windows server 2003 64 bit edition

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ted Byers wrote:
I do not know about Windows server 2003, because I don't have it, but I DO have the 64 bit version of Windows XP pro (and it seems to be much more responsive that its 32 bit counterpart on the AMD Turion64 in my system), and Postgresql works fine on it. As for the amount of memory, I have only 2GB RAM, but that still works fine for me. Being 32 bit, postgesql will almost certainly not take direct advantage of more than 4 GB of data, but if at least part of it works by spawning new threads or processes, use of more than 4 GB would be more a question of how the OS handles it, would it not? But if you don't need it to access more than 4 GB of memory, you should have no problems running it.

Unless Windows Server 2003 is radically different from XP, you should be fine based on what I have seen, at least if you use a binary distribution. I haven't tried compiling Postgresql myself, and I have not been able to get cygwin to install on 64 bit Windows. I would have thought cygwin programs would run like any other 32 bit app, but they don't. One of the things I look at is how 64 bit versions of an application behave relative to their 32 bit counterparts. I can do this with Perl (the 64 bit version from Activestate doesn't have any CPAN packages or even provide a way to find them, the CPAN executable runs but doesn't know about any archives, and when I tried pointing at 32 bit archives, the installation always failed), PHP, MS Visual studio and MS SQL Server, and MySQL. The bottom line is that the 32 bit Windows binary for Postgresql seems to work like any other 32 bit Windows application. But if you want it to directly use more than 4 GB memory, you probably need to build a 64 bit version yourself, with all the headaches that entails.

HTH

Ted

----- Original Message ----- From: "teknokrat" <teknokrat@xxxxxxxxx>
To: <pgsql-admin@xxxxxxxxxxxxxx>
Sent: Monday, February 12, 2007 9:04 AM
Subject: [ADMIN] pg on windows server 2003 64 bit edition


Can anyone tell me if the win32 version of postgresql will install and run on the 64 bit windows 2003 server? Will it work ok with ram > 4GB?

thanks

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


ok, thanks.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux