X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2430D1B4D3 for ; Sat, 13 Dec 2003 23:01:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49422-02 for ; Sat, 13 Dec 2003 19:00:40 -0400 (AST) Received: from visionlink.org (mail.visionlink.org [208.139.207.159]) by svr1.postgresql.org (Postfix) with SMTP id D4A84D1B467 for ; Sat, 13 Dec 2003 19:00:31 -0400 (AST) Received: from [65.100.170.142] (HELO [192.168.1.201]) by visionlink.org (Stalker SMTP Server 1.8b8) with ESMTP id S.0002315566 for ; Sat, 13 Dec 2003 16:01:46 -0700 Mime-Version: 1.0 X-Sender: bohmer@mail.visionlink.org Message-Id: In-Reply-To: References: <3FD961C5.9070204@persistent.co.in> Date: Sat, 13 Dec 2003 16:00:32 -0700 To: pgsql-performance@postgresql.org From: Jeff Bohmer Subject: Re: Hardware suggestions for Linux/PGSQL server Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/214 X-Sequence-Number: 5074 >Shridhar Daithankar wrote: >> >>FWIW, there are only two pieces of software that need 64bit aware >>for a typical server job. Kernel and glibc. Rest of the apps can do >>fine as 32 bits unless you are oracle and insist on outsmarting OS. >> >>In fact running 32 bit apps on 64 bit OS has plenty of advantages >>like effectively using the cache. Unless you need 64bit, going for >>64bit software is not advised. > >This is a good point. While doing research on this matter a few >months back, I saw comments by people testing 64-bit MySQL that some >operations would run faster and some slower due to the use of 64-bit >datatypes versus 32-bit. The best solution in the end is probably to >run 32-bit Postgres under a 64-bit kernel -- unless your DB tends to >have a lot of 64-bit datatypes. Thanks Shridhar and William, This advice has been very helpful. I would imagine a lot of folks are, or will soon be looking at 32- vs. 64-bit just for memory reasons and not 64-bit apps. - Jeff -- Jeff Bohmer VisionLink, Inc. _________________________________ 303.402.0170 www.visionlink.org _________________________________ People. Tools. Change. Community.