X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 07A59329DC4 for ; Mon, 27 Sep 2004 01:15:36 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39073-03 for ; Mon, 27 Sep 2004 00:15:25 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3518D329E39 for ; Mon, 27 Sep 2004 01:15:27 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i8R0FOfg039420 for ; Mon, 27 Sep 2004 00:15:24 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8QNnxLt034206 for pgsql-performance@postgresql.org; Sun, 26 Sep 2004 23:49:59 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: performance of PostgreSQL on 64 bit MAC OS X G5! Date: Sun, 26 Sep 2004 19:31:21 -0400 Organization: cbbrowne Computing Inc Lines: 25 Message-ID: References: <27CAD89B-0E5F-11D9-8B00-000A95AB8896@supplyfx.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:h/DBvSmnsBChljMSC2aGQW4ae8Y= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/274 X-Sequence-Number: 8402 Oops! qzhao@supplyfx.com (Qing Zhao) was seen spray-painting on a wall: > Is it because PostgreSQL 7.3.4 can't take advantage of the 64 bit > hardware or is it something else? PostgreSQL has been able to take advantage of 64 bit hardware WHEN THE OS SUPPORTS IT, for quite a few versions now. As far as I was aware, Mac OS-X was still deployed as a 32 bit operating system. Apple's advertising material seems deliberately ambiguous in this regard; it seems to imply there is no difference between 32- and 64-bit applications. To wit: "... This means that 32-bit applications that run on Mac OS X today will run natively on 64-bit PowerPC G5 Processor-based Macintosh computers, without the need for recompiling or additional optimizations." There are quite likely to be some additional "compiler incantations" required in order to compile applications as 64 bit apps that will be able to reference, internally, more than 4GB of RAM. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org'). http://www3.sympatico.ca/cbbrowne/sgml.html Tell a man that there are 400 billion stars, and he'll believe you. Tell him a bench has wet paint, and he has to touch it.