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
*** src/Makefile.shlib.orig Thu Sep 2 19:06:43 2004
--- src/Makefile.shlib Tue Sep 28 17:47:40 2004
***************
*** 150,157 ****
shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
ifeq ($(GCC), yes)
! SHLIB_LINK += `$(CC) -print-libgcc-file-name`
! endif
! ifeq ($(with_gnu_ld), yes)
! LINK.shared = $(CC) $(LDFLAGS) -shared -Wl,-h -Wl,$(soname)
else
LINK.shared = $(LD) +h $(soname) -b +b $(libdir)
--- 150,155 ----
shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
ifeq ($(GCC), yes)
! LINK.shared = $(CC) $(LDFLAGS) -shared -Wl,+h -Wl,$(soname) -Wl,+b -Wl,$(libdir)
! SHLIB_LINK += `$(CC) $(LDFLAGS) -print-libgcc-file-name`
else
LINK.shared = $(LD) +h $(soname) -b +b $(libdir)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
