Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-29 Thread Greg Smith
On Thu, 26 Jun 2008, Adam Rich wrote: Is there any benefit to running a 32-bit OS (rhel 5 in this case) on a server with more than 4 GB of memory? If you have more than 3GB of memory, you should be using a 64-bit OS. While theoretically the 32-bit code might be smaller which has some advanta

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Scott Marlowe
On Fri, Jun 27, 2008 at 10:21 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Douglas McNaught" <[EMAIL PROTECTED]> writes: >> On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver >> <[EMAIL PROTECTED]> wrote: >>> Not knowing about such things, I was scared by the following quote. > >> Distro support for 6

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Douglas McNaught
On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver <[EMAIL PROTECTED]> wrote: > Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I > wanted to hear. Sounds like there aren't any problems. > > Not knowing about such things, I was scared by the following quote. Perhaps > bi

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Tom Lane
"Douglas McNaught" <[EMAIL PROTECTED]> writes: > On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver > <[EMAIL PROTECTED]> wrote: >> Not knowing about such things, I was scared by the following quote. > Distro support for 64-bit x86 in 2004 was light-years behind where it > is now. A lot of stuff w

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Benjamin Weaver
Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I wanted to hear. Sounds like there aren't any problems. Not knowing about such things, I was scared by the following quote. Perhaps binaries do not need to be compiled as 64 bit binaries on a 64 bit machine? Or perhaps

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Tom Lane
Greg Smith <[EMAIL PROTECTED]> writes: > On Thu, 26 Jun 2008, Benjamin Weaver wrote: >> I have heard of problems arising from compiling PostGreSQL (8.3) on >> 64-bit processors. > From who? Perhaps someone who remembers PG 6.4 or thereabouts? Certainly any version released in the last couple of

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Ben
On Thu, 26 Jun 2008, Benjamin Weaver wrote: Dear All, 1. I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. What sort of problems am I likely to encounter and how should I fix them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core Xeon E54 2.3

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Douglas McNaught
On Thu, Jun 26, 2008 at 7:12 PM, Adam Rich <[EMAIL PROTECTED]> wrote: > >> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on >> 64-bit >> processors. What sort of problems am I likely to encounter and how >> should I fix >> them? We are will run Linux Redhat 5 on a Dell PE29

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Greg Smith
On Thu, 26 Jun 2008, Benjamin Weaver wrote: I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. From who? We are will run Linux Redhat 5 If there were any problems compiling and running PostgreSQL on 64-bit RHEL5, I wouldn't be writing this message rig

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Adam Rich
> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on > 64-bit > processors. What sort of problems am I likely to encounter and how > should I fix > them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core > Xeon E54 > 2.33 GHz, and a Dell PE2950 III Quad Core Xeon

[GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Benjamin Weaver
Dear All, 1. I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. What sort of problems am I likely to encounter and how should I fix them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core Xeon E54 2.33 GHz, and a Dell PE2950 III Quad Core Xeon L53