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

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 it's way out of date (2004) or simply wrong.

from

http://www.osnews.com/story/5768/Are_64-bit_Binaries_Really_Slower_than_32-bit_Binaries_/page3/

"
...

The Compile Factor

Getting applications to compile as 64-bit binaries can be tricky. The build
process for some applications, such as OpenSSL, have 64-bit specifically in
mind, and require nothing fancy. Others, like MySQL and especially PostgreSQL (I
was originally going to include PostgreSQL benchmarks) took quite a bit of
tweaking. There are compiler flags, linker flags, and you'll likely end up in a
position where you need to know your way around a Makefile..."

In message <23234(dot)1214523814(at)sss(dot)pgh(dot)pa(dot)us> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Greg Smith <gsmith(at)gregsmith(dot)com> 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 years has been
> tested about as heavily on 64-bit platforms as 32-bit.
>
> regards, tom lane

--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri, Greek Fragments Projects, Oxford
email: benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk
phone: (0)1865 610236