Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B32879FB27A for ; Thu, 1 Feb 2007 19:04:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 44457-05 for ; Thu, 1 Feb 2007 19:04:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C594D9FB272 for ; Thu, 1 Feb 2007 19:04:04 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 7C26530E07; Fri, 2 Feb 2007 00:04:03 +0100 (MET) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: Index Anding Date: Thu, 01 Feb 2007 17:45:06 -0500 Organization: cbbrowne Computing Inc Lines: 33 Message-ID: <604pq5h4zx.fsf@dba2.int.libertyrms.com> References: <20070131155248.GA3073@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:qXxbLQOVRKbGm23RcSoisC7sfXk= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/6 X-Sequence-Number: 27340 ajs@crankycanuck.ca (Andrew Sullivan) writes: >> Does postgres provide 64 bit support? If so is there a precompiled 64 >> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64 >> bit GCC I have not gotten stabilized. (I cold use a tip in that >> direction if anyone lese has experienced similar issues) > > I know we've managed to get it to work using gcc, but I haven't had > to do it in a while (ask on -general or -admin, I suggest). More > important is to make sure you tell the compiler to use all the > memory. For reasons that are completely beyond my ken, AIX imposes > a memory limitation on every program at compile time. There are > some hints about this in the FAQ_AIX. Here's the environment data submitted to ./configure for a recent build of 8.1.5: pgdba@ydb1 $ ./pg_config --configure '--prefix=/where/I/stow/it '--enable-thread-safety' '--enable-debug' '--with-libraries=/opt/freeware/lib' '--with-includes=/opt/freeware/include' 'CC=gcc -maix64' 'LDFLAGS=-Wl,-bmaxdata:0x80000000,-bbigtoc' Note that you also need to export: export OBJECT_MODE=64 And you need to make sure that you are using the AIX ld, and not GNU ld... For version 7.4, it was considerably fiddlier to do a build. For 8.2, it is neither overly baroque nor overly unpleasant, which I consider a direct result of the combination of Seneca Cunningham's reports to -hackers/-ports as well as BuildFarm runs... -- (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc")) http://cbbrowne.com/info/finances.html Rules of the Evil Overlord #30. "All bumbling conjurers, clumsy squires, no-talent bards, and cowardly thieves in the land will be preemptively put to death. My foes will surely give up and abandon their quest if they have no source of comic relief."