Re: Pgsql 7.4/8.0 on IA64 HP-UX 11i?

On Tuesday September 28 2004 1:12, Ed L. wrote:
>
> The HPUX gurus on http://forums1.itrc.hp.com testify that kernel caches
> above approximately 600MB are counter-productive to performance.  But we
> have 16GB of RAM we definitely want to utilize for caching.  Therefore,
> we've set the kernel cache to 500MB and now wish to dramatically increase
> the size of the PostgreSQL DB cache to take advantage of this RAM,
> possibly as large as 8GB for a single cluster.
>
> The Pgsql build scripts are building 32-bit pgsql executables by default,
> and thus I'm concerned I'm not going to take advantage of the available
> RAM for DB caching.
>
> How do I build 64-bit pgsql executables?

Well, for what it's worth, here's how I finally got postgresql 8.0.0beta3 to
build 64-bit executables on one HP-UX B.11.23 ia64 system using a gcc 3.4.2
depot-installed compiler (thanks to a prior patch from Shinji Teragaito).
All 96 regression tests passed.

export CC=gcc CFLAGS="-O2 -mlp64" LDFLAGS=-mlp64
./configure --without-readline --without-zlib

then apply attached patch.

Ed