I appreciate this may have been answered before but I can find no definitive answer so please bear with me...
I found a good explanation here but it's a bit out of date: http://blog.hagander.net/archives/73-PostgreSQL-vs-64-bit-windows.html We have a 64 bit Win 2008 machine with 16 GB RAM Our 32 bit client applications are on 32 bit windows. We have developed and tested against 32 bit postgres. Would it be better to upgrade postgres to (or start out with) 64 bit? As I understand it, under windows you're better off leaving the memory for the OS as postgres relies heavily on OS level caching and, as postgres is multi-process, in theory each process (and therefore connection) could address up to 4 GB anyway. Also, I understand that 64 bit can handle larger numbers (and possibly move dates around more efficiently) but are there any fundamental differences between the functionality or behaviour in 32 / 64 postgres for windows? Thanks for your help, Regards, Regards, Russell Keane INPS Tel: +44 (0)20 7501 7277 [cid:image001.jpg@01CE0546.44E37510] Follow us<https://twitter.com/INPSnews> on twitter | visit www.inps.co.uk<http://www.inps.co.uk/> ________________________________ Registered name: In Practice Systems Ltd. Registered address: The Bread Factory, 1a Broughton Street, London, SW8 3QJ Registered Number: 1788577 Registered in England Visit our Internet Web site at www.inps.co.uk The information in this internet email is confidential and is intended solely for the addressee. Access, copying or re-use of information in it by anyone else is not authorised. Any views or opinions presented are solely those of the author and do not necessarily represent those of INPS or any of its affiliates. If you are not the intended recipient please contact is.helpd...@inps.co.uk
<<inline: image001.jpg>>
